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?

Thanks
Jaime

>Hi Jaime.
>
>>Will this method update indexes as well when adding records?
>
>Yes.
>
>Doug