Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
CursorAdapter question
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01464565
Message ID:
01464585
Vues:
40
>>>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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform