Philip B escreveu:
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
If you really need to use SEEK and indexes, you can create the indexes
at the AFTERCURSORFILL event. But I suggest that you edit the SELECTCMD
property to return only the row that you need from the table. And if you
really need to get all the records, set the property FETCHSIZE to -1.
--
Aílsom F. Heringer
[EMAIL PROTECTED]
Skype: ailsom.osklen
Analista de Sistemas
----------------------------------
Osklen
Departamento de Informática
Rio de Janeiro - RJ
BRASIL
http://www.osklen.com.br
55 21 22198971
_______________________________________________
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.
