General information
Category:
Internet applications
Hi Michael,
>To create a table via VFP's ODBC driver the SQL command syntax would be:
>
>CREATE DBF TableName (FIELD1 FieldType (width [, precision]),FIELD2 FieldType (width [, precision]))...
>...Check VFP's help under CREATE TABLE SQL for more information.
>Note that you must include the destination path of the DBF to be created regardless of the DSN source. The above code works with latest VFP ODBC driver configured for FREE tables. I have not tested with VFP's ODBC DBC container nor have I used VFP's odbc driver with cold fusion.
>
>HTH,
>Mike
Sorry I have not had a chance to try the code, I hope to give it a go today. Thanks for your suggestion, I'll let you know how it turns out.
Have a Great New Year.
Ed
Previous
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