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.