I'm just now getting into using the VFP 9 CursorAdapters on a form using
the ADO data connection to an SQL 2K Server DB.
Question I have... is there anyway to put indexes on the CursorAdapter
in order to use the seek() function rather than LOCATE ?
Or, is there a better way to SEEK using a method on the Adapter ???
Also, is there a more efficient way to open the adapters? It's taking
so long to open, I have them set to retrieve all records because I need
all the records to produce some temp tables that are in Grids on the
screen... I saw the option to only retrieve 100 or so records and Fetch
as needed... how can I make sure I pull all the records from the
CursorAdapter when I perform an SQL-Select from the cursor tied to the
adapter into a temp file??
T.I.A.
Philip
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
