Thanks Mike and Aílsom,
I do have the fetch property set to -1.
The problem I have is not completely understanding how to retrieve more
records from the original cursor.
My screen has 10 pages on it with 10 grids (1 on each page)
Each grid represents a different set of data from my sales order detail
table.
So, I created a CursorAdapter in the D.E. that initially opens the Sales
Order Detail table from the SQL Server, pulling all valid SO records.
I then create temporary tables for each grid pulling only certain
classes of items (10 distinct classes).
I need these temporary tables because I allow the user to interactively
change the sort order by clicking on the header of each column to resort
each grid as well as interactive searches on each column...
My limited knowledge tells me to then make the cursoradapter for the
Sales Order Detail table pull all the records so that I can pull the
different groups from its results into each temp table.
How could I pull the different groups for each temp table if my initial
results are just 100 records in the cursoradapter?
The other caveat is that I need to update the cursor adapter for changes
that are done in each grid...
(Sorry for the long post...)
Philip
Ailsom F. Heringer (Osklen) wrote:
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.
_______________________________________________
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.
