I am searching the last record i save using the BOF() but it does not search the last record instead the first record viewed.
whats wrong in my code?
SELECT transaction
SET ORDER to id
LOCATE FOR name = ALLTRIM(thisform.txtname.Value)
IF FOUND()
IF !BOF() then
thisform.txtctcnum.Value = ctcnum
thisform.txtdateissued.Value = dateissued
endif
ENDIF
zhed
whats wrong in my code?
SELECT transaction
SET ORDER to id
LOCATE FOR name = ALLTRIM(thisform.txtname.Value)
IF FOUND()
IF !BOF() then
thisform.txtctcnum.Value = ctcnum
thisform.txtdateissued.Value = dateissued
endif
ENDIF
zhed