I have to search in an archive if an Id exists or not
I get the variable Chat_Id from a hash and I saw that it is a numeric variable
in the archive where I have to look for this variable I have a string field and the archive is indexed in this way
the structure of archive is
the problem is that the search never recognizes the ID number, where is the error?
I get the variable Chat_Id from a hash and I saw that it is a numeric variable
in the archive where I have to look for this variable I have a string field and the archive is indexed in this way
INDEX ON UPPER(NumeroID) TAG TEACH01 EVAL (oProgress:SetPos(nProgress++), Sysrefresh()) EVERY 1the structure of archive is
DbCreate(cDir+'TE', { { "NumeroId", "C", 20, 0 },;
{ "fname", "C", 20, 0 },;
{ "uname", "C", 20, 0 },;
{ "lname", "C", 20, 0 },;
{ "isteacher", "L", 1, 0},;
{ "isadmin", "L", 1, 0} }, 'DBFCDX')so when I do the research I do this waycChiaveId:=alltrim(str(Chat_Id))
SELECT TE
TE->(OrdSetFocus(1))
TE->(DbGoTop())
if ! TE->(DbSeek( cChiaveId, .t. ))
else
lKnown:=.t.
listeacher= TE->isteacher
lisadmin := TE->isadmin
endifthe problem is that the search never recognizes the ID number, where is the error?
Since from 1991/1992 ( fw for clipper Rel. 14.4 - Momos)
I use : FiveWin for Harbour March-April 2024 - Harbour 3.2.0dev (harbour_bcc770_32_20240309) - Bcc7.70 - xMate ver. 1.15.3 - PellesC - mail: silvio[dot]falconi[at]gmail[dot]com
I use : FiveWin for Harbour March-April 2024 - Harbour 3.2.0dev (harbour_bcc770_32_20240309) - Bcc7.70 - xMate ver. 1.15.3 - PellesC - mail: silvio[dot]falconi[at]gmail[dot]com
