General information
Category:
COM/DCOM and OLE Automation
>>>... 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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only