Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CursorAdapter question
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01464565
Message ID:
01464585
Views:
41
>>>I'm connecting to a small SQL Server table via a cursoradapter. I am getting an error that says "index or expression does not match an existing member of the collection" (error 2061) after I do the CursorFill (no records are returned, but CursorFill returns .t.). There are only 16 fields in the table and 27 records, not that it should matter. I get the error info from calling AERROR, of course. The third element in the array it creates is "ENABLED". It's just kind of an odd error to get with a CursorAdapter, it seems. Does anyone have any suggestions here?
>>>
>>>Thanks,
>>>
>>>Russell Campbell
>>
>>
>>No, If CA CursorFill() returns .t., you get and error from somewhere else. That is not a CA error.
>>It is a Collection class error.
>>
>>You should run SQL Profiler, and check what CA send to SQL Server when you run CursorFill().
>
>Yeah, it does seem that it's coming from somewhere else. Yet I've got this as simple as I can make it and I get no records in the cursor. I'm just doing SELECT * FROM STATECOORDINATORS.
>
>I'll try the profiler. Let me know if you have any other thoughts on this.

Could you script CA?
What you use as DataSourceType?
What is your connection string?
Did you get an EMPTY cursor or the cursor didn't created at all?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform