Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Rows in an ADO recordset returned from a Command object
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00824028
Message ID:
00824067
Vues:
24
>Never mind, gang -- I'm backwards. It's .BOF and .EOF I need, not Fields(x).Value. Sorry...it's been a long day. Disregard...

There's some stuff in download #9840 that might be helpful.
>
>
>
>>Hi folks,
>>
>>Anybody know, right off the top of the noggin, how to count the rows in an ADO recordset returned as the result of a SQL statement sent through the Command object?
>>
>>RecordCount is always -1, so that won't work. Spinning through the RS blows an error as soon as you hit a value of x for Fields(x).Value that doesn't exist.
>>
>>Better yet, can I pass SQL a parameter with the Command object that says "client-side cursor" the same way I can with a Recordset object?
>>
>>I need this one quick, gang...
>>
>>TIA,
Imagination is more important than knowledge
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform