Use AERROR() function to get detailed info about ODBC error.

>Hello All, I need to update a SQL Server 7 table from my VFP 7 app, the table ( mastcust ) has a structure as follows
>
>
>masterref char (10) not null,
>amenddate [datetime] null
>...
>a few more fields of the same types as above
>
>I can update the table using a remote view but would prefer to use SPT, this is what I've tried without success
>
>
>Connection code here ( no problem )
>
>mystr = "Insert into mastcust (masterref,amenddate) values('0000000001',?m.mydate)"
>
>sqlprepare(handle,mystr) && Ok so far
>
>m.mydate = date()
>
>retval = sqlexecute(handle) && returns -1
>
>
>any ideas ?