Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How select Table
Message
De
06/01/2006 10:30:17
 
 
À
06/01/2006 10:25:47
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Versions des environnements
Visual FoxPro:
VFP 8
OS:
Windows XP SP1
Network:
Windows XP
Database:
MySQL
Divers
Thread ID:
01084067
Message ID:
01084072
Vues:
8
>I use 'SQLSTRINGCONNECT' to etablish connection to my database (mysql) . How can select tables

Once you get a establish a connection you get a positive number as a return. That is the file handle that you save in a variable or object property.

You use that handle when doing a query to the remote database to return data.
SQLEXEC(nHandle, cSQLQuery, cCursorName)

If the query was successful (returns a positive number), you now have a cursor (using the name you chose) with the results which could be 0 or more records.

This you manipulate as any other VFP table:
Select MyResultCursor
BROWSE
USE MyResultCursor
etc.


Alex Feldstein, MCP, Microsoft MVP
VFP Tips: English - Spanish
Website - Blog - Photo Gallery


"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform