Information générale
Catégorie:
COM/DCOM et OLE Automation
I did get your class to operate properly work. Here are the results with the same 500K result set:
60 secs which was pretty good (much better than with using .GetRows) but still not as good as ODBC which clocked in at 44 secs. We've decided to continue using ODBC but do recognize that we will be changing in the future to OLE DB, and probably sooner rather than much later.
Thanks,
Steve
>>>>... but this is a general question regarding the Recordset object. The .GetRows() method accepts 3 parameters, the third can be an array with a field list. I've found that the size of the array is limited because if I use 3 field names it works but if I try the fields for the whole table (54 fields), then I get a C5 error.
>>Not sure what version I have here but found that the limit is 32 fields.
>
>This is not a GetRows() limitation. The problem is in VFP limit of 65,000 elements in array. By default GetRows() in jcRStoCursor retrieves 1999 rows at a time. In this case the fields limit will be 65000/1999 = 32.5
>You could try to decrease lnMagic number in jcRStoCursor to solve this problem.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement