Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Trouble opening my SQL tables in my program
Message
De
29/07/2011 14:13:25
 
 
À
29/07/2011 13:42:03
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01519607
Message ID:
01519618
Vues:
37
>You can't use the USE command with tables on a server. You have to send commands to the server to bring the data into local cursors. For example, if you want to bring the entire UserAccess table into a local cursor (which isn't really a good idea unless the table is quite small), you'd do something like:
>
>
>IF SQLExec(m.Handle, "SELECT * FROM UserAccess", "UserAccess")
>   * Success
>ELSE
>   * The query failed. You'll need to act appropriately.
>ENDIF
>
>* If you were successful, at this point, you have a cursor named UserAccess that you can
>* work with. Be careful not to close it, until you're really done with it.
>
>
>Tamar

ok thanks for the tip: but if am right (m.Handle, "SELECT * FROM UserAccess", "UserAccess") basically takes the connection handle from memory , the command and cursor name so.... im not so sure as to why im getting a data mismatch error
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform