>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?
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer