Hi,
I have some code that attempts to retrieve the nearest matching record using the criteria that the user enters. Unfortunately, VFP is not reacting the way I'm expecting it to.
I have a three character field which is the primary key field in the table. If the user enters the first character and performs the search, it should retrieve the a record with the first character. However, what's happening instead is that it returns the last record. I'll provide an example that will better explain this:
The table holds the following test data:
CAN
DH2
DUH
EUR
PND
RUB
UDB
USD
The code that I'm using is as follows:
LOCAL lnRecNo
lnRecNo = RECNO("CurrMast")
GO TOP
SET EXACT OFF
SEEK UPPER(ALLTRIM(THISFORM.txtCurrID.Value))
SET EXACT ON
IF NOT FOUND("CurrMast")
GO lnRecNo IN CurrMast
MsgBox("Currency was not found.",,,16)
RETURN .F.
ENDIF
When I attempt to search for "D" in the textbox, the returning record is USD instead of DH2 or DUH. If I do a search for "DH" it'll still return USD. If I do a search for "DU" it'll return DUH. If I do a search for "C", it'll return CAN. What am I doing wrong?
Thanks in advance,
Ronald Suen
Epic Information Solutions Inc.
Ph: (780) 488-4418
Fax: (780) 488-0402