Geeeeee...
When i first got the error i immediately changed to single quote, but it still failed...browsing through the history in my command window, i saw why...i used "sele " instead of "select " when i tried the single quote :-)
Thanks!!
If you have an idea for my main issue here, i'll be glad to have it...

Jaime

>>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" ) &&& this fails with same error 1229
>>lnResult = sqlexec(lnHandle, "select * from countries where show=chr(89)","myCursor" ) &&& no error...

>>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