Information générale
Catégorie:
Contrôles ActiveX en VFP
>Does anyone have some examples of accessing VFP tables (free and in a DBC) via VB -- especially using ADO 2.0?
>
>I'd love to get a pointer toward some stuff to look at to bone up on this stuff.
>
>-- jas
Jeff,
Using the ADO Control is very easy all you need is a ODBC connection to the VFP DBC.
Here is a programmatic example:
Dim conn As New adodb.connection
Dim rs As New adodb.connection
Dim connectionstring As String
Dim SQLString As String
ConnectString = "DRIVER=Microsoft Visual FoxPro Driver;" & _
"UID=;SourceType=DBC;Exclusive=No;" & _
"BackgroundFetch=Yes;Collate=Machine;" & _
"SourceDB=c:\logbook\logbook.dbc """
SQLString = "Select * from Mission"
'Open connection
conn.Open (ConnectString)
' open recordset object
With rs
.CursorType = adOpenStatic
.Source = SQLString .ActiveConnectin = conn
.LockType = adLockBatchOptimistic
.Open
EndWith
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement