Try this:

gnConnHandle = sqlstringconnect( blah blah blah )
cCmdString = 'Insert into mytab (val1, val2) values ("Test1","Test2")'
lResults = SQLExec( gnConnHandle, cCmdString )

If lResults = -1
= MessageBox( 'Insert Failed' )
Else
= MessageBox( 'Insert worked' )
Endif