>Hi Fred
>It fails with error 1229 ( too few arguments ), it says it expects 2...
>I think i found the reason for the error, i got the same error in a SELECT statement involving a character string:
>lnResult = sqlexec(lnHandle, [select * from countries where show="Y"], "myCursor" )
>lnResult = sqlexec(lnHandle, "select * from countries where show=chr(89)","myCursor" )
>I have character values in my INSERT command, so that's probably triggering the same error message.
>While i'd like to know how to pass the strings in my sql command, the main issue remains: when i insert a record in a specific db3 table, how do i update respective Index files??
For SQL, you need to use single quote, not double quote.
lnResult = sqlexec(lnHandle, [select * from countries where show='Y'], "myCursor" ) &&& this fails with same error 1229