Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SEEK() Equivalent for MSSQL, MySQL, Oracle
Message
De
28/10/2003 06:31:15
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00841003
Message ID:
00843431
Vues:
24
>For anyone who is interested, I have come across a work around that allows a developer to access remote data the same as VB.
>
>The trick is create an object of either ADO or RDO, pass a SQL query and it will retrieve a recordset in the same manner as VB and obviously all the ADO/RDO index searching facilities are available.
>
>I have not tested this yet, but if someone can verify this before I can, all the better.

AFAIK ADO set needs to be serverside cursor and provider must support indexes for that.
IMHO an expensive solution.
As Martin and Andy already noted you're working with data sets. It'd be easier to create indexes on the SPT cursor if you need, rather than to manage ADO.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform