Subject Cannot locate a record
From Pieter van Heerden <psvh@mweb.co.za>
Date Thu, 22 Mar 2018 10:35:32 -0400
Newsgroups dbase.getting-started

dbase 10 on Windows 10 on a 64-bit laptop.

I am trying to locate weather station INDS00003 in a weather station data table with about 5500 records.   The weather station is in the table and can be found from the tables menu system find function.  However, when setting up a code to find the station in the table, it does not find the station.  The following code is used:

? _app.stationid, form.rowset.fields["stationid"].value
form.rowset.applylocate("StationID = '" + _app.stationid + "'")
? _app.stationid, form.rowset.fields["stationid"].value

The print lines are there to follow results in order to try and solve the problem.  The printed results arre:

INDS00003 AFGC00021 (Quite correct)
INDS00003  (The table value was not found - at endoffile position)

The applyLocate line results in a run-through of the table without finding the record to the EndOfFile  position.

I have tried changing the LocateOptions to 3, with no luck.