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