Hi,

Im using SQLPassthrough to insert a new record in a .dbf table. The problem is that when I execute the sql syntax, it returns a positive value meaning that the inserting was successful. But when I try to browse for the new record, it was not inserted on the table. Any Idea? Here is an example on how my codes look like.

csql = [Insert into bcmi!players(cardno,]]+;
[queno)]+;
[values(]+;
str(var_cardno) +[,]+;
str(var_queno) +[)]

nResult = SQLEXEC(thisform.vconnstr,csql)


In my example, nResult acquired a value of 1 which means that the code was executed without errors. How come the new record is not on the players table?

Please Help...
Thanks in advance