Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How do I use the Grid ??
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
How do I use the Grid ??
Divers
Thread ID:
00622583
Message ID:
00622583
Vues:
48
Sorry for the 2 last messages... I had problems with my keyboard !!

I'm connecting a Microsoft SQL server using the following syntax:

ChaineConnection = "driver={SQL Server}; SERVER=SERVEUR2000\SQL_SERVER; DATABASE=silo"

oConnection=CREATEOBJECT("ADODB.Connection")
WITH oConnection
.CommandTimeout = 60
.ConnectionTimeout = 30
.ConnectionString = ChaineConnection
.CursorLocation = 3 && Curseur Cote Client
.Mode = 3 && Mode Lecture Ecriture
ENDWITH

oConnection.Open(,,, 16) && Connection Asynchrone

DO WHILE oConnection.State = 2 && En Connection
WAIT WINDOW NOWAIT "EN COURS DE CONNECTION"
ENDDO

WAIT CLEAR




after that, I create a recordset using the following syntax :

recordset = oConnection.execute("SELECT * FROM Client")



Now I would like to know how to use the grid that comes with VFP with that !

Thanks in advance...
********************************************

Benoit Grenier


encoder@silogic.ca (Job)
encoder@sympatico.ca (home)
Web site : www.silogic.ca
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform