Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How do I use the Grid ??
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
How do I use the Grid ??
Miscellaneous
Thread ID:
00622583
Message ID:
00622583
Views:
49
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
Next
Reply
Map
View

Click here to load this message in the networking platform