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 ?