I'm learning how to use SQLEXEC and have run into the following problem.

Use localFoxproTable
Scan
lnsuccess = SQLEXEC(gnConnHandle, "INSERT INTO Sync_Box (field1) values (localFoxproTable.field1)")
Endscan

My handle is good but lnsuccess is -1

Both fieldtypes are numeric.

What am I doing wrong? Thanks in advance.