>>I tried your tips but still no results here is what I found, how can I overcome this ?
>>
>>Drawings(table) table is open with 3 as well as Enterdrawpart(view)
>>When I save with the code below a new record the indexes are not updated but if it is an existing record it is updated.
>>AS soon as I remove the Transactions command everything is OK.
>>
>>updsuccess = .F.
>>DIMENSION atablesused[2,1]
>>DIMENSION aerrors[1]
>>atablesused[2,1]= "Drawings"
>>atablesused[1,1]= "Enterdrawpart"
>>*BEGIN TRANSACTION
>>FOR i = 1 TO 2
>> SELECT (atablesused[i,1])
>>* BEGIN TRANSACTION
>> updsuccess = TABLEUPDATE(.t.,.f.)
>> IF updsuccess
>>* END TRANSACTION
>> LOOP
>> ELSE
>>* ROLLBACK
>> ENDIF
>> some error handling
>> ntoterr=AERROR(aerrors)
>> DO CASE
>> CASE aerrors[1,1] = 1539
>> blabla
>> ENDCASE
>> EXIT && No point trying the next one
>>ENDFOR
>>IF updsuccess
>>* END TRANSACTION
>>ELSE
>>* ROLLBACK
>>ENDIF
>>RETURN updsuccess
>>
>>
>>>>Hi there,
>>>>
>>>>I have got a form using optimistic, when I add a new record my indexes are not updated ! When I remove the buffering code and set the table to no buffering everything is ok.
>>>>
>>>>Where should I start ?
>>>>
>>>>Regards,
>>>>
>>>>Xavier
>>>
>>>
>>>Two things:
>>>
>>>1) After the TableUpdate(), issue the FLUSH command.
>>>2) Turn off all write cache on the server.
>
>
>Are all tables in the same DBC? Yes they are !

Thanks