Create a FoxPro Table From ASP 1

[foxylady]

Does anyone know how to dynamically create a table(.dbf) file from ASP?

Thanks

 

[jonscott8]

Using ADO, you can use the Connection object to perform DDL operations, such as creating a table. Example VBS:

SET oConn = CreateObject("ADODB.Connection&quot
oConn.Open "dsn=MyDSN"
oConn.Execute "CREATE TABLE C:\Table2(Field1 c(10))"
oConn.Close
SET oConn = NOTHING

There is also ADOX - but I've never used it on VFP tables/databases.

If you using this in ASP as you mention, make sure your DSN's Fetch data in background option is disabled. If you're not using a DSN, make sure your connection string sets BackgroundFetch=No. Failing to do this can eventually crash IIS. Jon Hawkins

 

[foxylady]

I understand that part but how do you put data in it from a recordset?

 

[jonscott8]

See thread333-193795 Jon Hawkins

 

[foxylady]

I am trying to create a foxpro .dbf on a client machine and put data that I already have in a recordset to that table that i just created