General information
Category:
Database DAO/RDO/ODBC/ADO
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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only