Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Foxpro table creation in VB
Message
Information générale
Forum:
Visual Basic
Catégorie:
Bases de données DAO/RDO/ODBC/ADO
Divers
Thread ID:
00291969
Message ID:
00292356
Vues:
18
Joe,
MSFT is supposedly working on a true OLEDB provider for VFP. ADOX has built in functionality to create tables, but you need a true OLE DB provider, not the generic ODBC driver. For example, the following code will create a VFP table with a true OLE DB provider:

Dim table As New Table
Dim catalog As New ADOX.Catalog

catalog.ActiveConnection = "Driver=Microsoft Visual Foxpro Driver;UID=;SourceType=DBF;Deleted=YES;Null=NO;SourceDB=E:\DEV\VISUALMM\DATA"
catalog.open
table.Name = "MyTable"
table.Columns.Append "Column1", adInteger
table.Columns.Append "Column2", adInteger
table.Columns.Append "Column3", adVarWChar, 50

catalog.tables.append tbl ' OK for OLEDB-Will generate error w/ODBC driver

>Anyone programmaticly created a foxpro table using VB? I could use some pointers. :)
>
>My Humble thanks in advance.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform