Try using CHAR instead of C

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

>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)
>