Hi,

I'm trying to create a table using SPT, with the sequence below. It does nothing, even returns an error.

Am I doing something wrong or it just can't be done?

TIA,

Fernando

 nSQLHandle = SqlConnect ("MyVFPDataSource")

 If nSQLHandle = -1
    MessageBox ("Connection failed")
    Return
 endif

 cObjtSQLcommand = "Create Table MyTable (Name C(40))"

 If SqlExec (nSQLHandle, cObjtSQLcommand) <> 1
    MessageBox ("SqlExec error")
 endif 
 
 SqlDisconnect (nSQLHandle)