This is the code I am using, the UPDATE appears to work fine, but not the INSERT, I get a -1 ,
I´ve also tried it without the SQLPREPARE, but to no avail.




lnconn=SQLCONNECT("saeacces")
? lnconn
?SQLPREPARE(lnconn, "INSERT INTO inve01(num_reg, clv_art, status) VALUES (79, '12100', 'A')")
?SQLEXEC(lnconn)
SQLEXEC(LNCONN,"UPDATE INVE01 SET UNI_EMP = UNI_EMP+11 WHERE CLV_ART = 'HUESO'")
?SQLCOMMIT(lnconn)
?SQLEXEC(lnconn,"select * from inve01")
BROWSE
?SQLDISCONNECT(lnconn)