Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

help in using EOF for searching

Status
Not open for further replies.
zhed0708

zhed0708

IS-IT--Management
Jun 25, 2011
41
PH
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
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

german12
  • Locked
  • Question
Searching in a big memo-field for a special info. 1
2
Replies
24
Views
323
Chris Miller
Chris Miller
ravicoder
  • Locked
  • Question
Help requested in foxcharts library
Replies
6
Views
251
ravicoder
ravicoder
RahulBhatia
  • Locked
  • Question
Using Dos Foxpro 2.6 in 2024 2
Replies
9
Views
709
tomk3
tomk3
SitesMasstec
  • Locked
  • Question
Selecting record from a Grid for use in another form
Replies
14
Views
873
Scott24x7
Scott24x7
Piotr Czekalski
  • Locked
  • Question
Safe limit size for EXE file in FVP9 1
2 3
Replies
47
Views
3K
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top