General information
Category:
Coding, syntax & commands
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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only