All,
I am querying a VFP table that has about 1.5 million records. The table is indexed on a date field called aaddb. My query shows that it returned 13,533 records on the status bar. Then the status bar message changes and it states: Tcursor(c:\arrestees.dbf) Record: 24/1427204.
Only the records I have selected show in the browse window. However if I do a ?reccount() it shows that there are 1427204 records in my cursor. If I select all of the records from the cursor into a new cursor I get all 1427204 records from the original table.
This is my query.
SELECT * FROM arrestees where BETWEEN(aaddb, CTOD('12/30/1939'), CTOD('12/29/1941')) into cursor tCursor
How can I get just the records I am trying to select? This is a new one on me.
James Harvey, MCP
Memphis Police Department
225 Channel Three DR
Memphis, TN 38103
901 577-1296