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

Jaime
>>Hi Doug
>>I finally got the time to check this, but i do not see how this can update indexes. I am using the following:

>>lnHandle = sqlstringconnect('Driver=Microsoft dBase Driver (*.dbf);dbq=c:\work\olddb3') && gives correct handle
>>lnResult = sqlexec(lnHandle, "select * from table1", "test" ) && works
>>lnResult = sqlexec(lnHadle, "insert into table1 (field1,field2) values ( val1,val2 )", "test" ) &&& does not work, lnresult=-1
>>

>>My question is, assuming table1 has index atable1.ndx, btable1.ndx, ctable1.ndx:
>> how can i add/update records in Table1 while it is used in the network, and still updating all 3 indexes?
>
>
>So what is the information for AERROR() on the SPT that fails?