Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VB and VFP 5.0/6.0 Tables
Message
 
À
18/09/1998 12:36:22
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00138299
Message ID:
00138387
Vues:
12
Morys,
The easiest method is to use ADO to query data from a VFP database.

Do the following:
1. Create a SYSTEM dsn called VFPADO (point it at your database)
2. Run the follwing code

Set oConn = CreateObject("ADODB.Connection")
oConn.Open "VFPADO","",""

Set oRecs = CreateObject("ADODB.Recordset")
oRecs.Open "Select * from customer",oConn,3,3

'Substutute your table above in the SELECT line
' and below in the fields list
Do While Not oRecs.Eof
Debug.print oRecs("Lastname")
oRecs.MoveNext
Loop

Hope that helps...
Rod
Rod Paddock
Editor in Chief CoDe Magazine
President Dash Point Software, Inc.
VP Red Matrix Technologies,Inc.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform