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!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: zedlands
- Order by date
-
?Equivalent of SEEK
Dear Benson, In general, its good practice to use SQL statements instead of LOCATE or SEEK, especially in client/server applications. LOCATE and SEEK search through the table row by row (serial search) which can be slow if the computer is not powerful enough or the network is overloaded. So...- zedlands
- Post #7
- Forum: Microsoft: FoxPro
-
?Equivalent of SEEK
...correction LOCAL myStockCode myStockCode = set_stock_code select myTable LOCATE FOR myTable.stock_code = myStockCode Zed- zedlands
- Post #5
- Forum: Microsoft: FoxPro
-
?Equivalent of SEEK
try this select myTable SELECT * FROM myTable WHERE m.stock_code = myStockCode or select myTable LOCATE FOR m.stock_code = myStockCode myForm.Refresh Zed Lands- zedlands
- Post #4
- Forum: Microsoft: FoxPro
-
?Equivalent of SEEK
If I have understood correctly, you are looking for alternative ways to find a record in a table using VFP. In this case, instead of seek, try LOCATE (for serial search), or use an SQL statement with a WHERE clause for the desired record's record number ( RECNO() ) eg. SELECT FROM myTable *...- zedlands
- Post #2
- Forum: Microsoft: FoxPro
