PMFJI, Mark

Have you tryed the aerror() in vfp to see what the error returned is?

HTH
Beth


>>OK, then maybe it's bombing before it even gets to the end.
>>
>>Can you execute it from SQL management studio (or query analyzer) and step through it to see where it might be returning a -1 or an error?
>I did, works fine from query analyzer.
>
>It is in my Fox I have a problem:
>lnRetVal = SQLEXEC(tnConection, tcSqlCommand)
>and lnRetVal is -1.