Good morning/evening...

Is ENTERDRAWPART a view on the table DRAWINGS? I'm assuming not.

Is the table for ENTERDRAWPART a child table to DRAWINGS? If so, are you enforcing RI on it?

If so, then should you TABLEUPDATE DRAWINGS before ENTERDRAWPART? Do you have the key and updateable fields in the view set correctly?

Why do you nest your transactions?

When you include the transaction processing, which ROLLBACK is being hit?


>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