Re: Problems with the On-Insert trigger (Forms)

<jordi_gine_at_my-deja.com> wrote in message news:8ntj90$ulp$1_at_nnrp1.deja.com...
> Hello:
>
> I have redefined the on-insert trigger, to do some processing and
> finally issue an insert statement.
> This seems to work well, but if I try to update any of the fields after
> inserting the record, I get the following error_message:
> "frm-40654:Record has been updated by another user. Re-query to see
> change"
>
> I have even removed all the extra processing in the trigger, leaving
> only the insert statement but still get the error message.
> On the other hand, if I redefine the on-Insert trigger and just call
> the Insert_Record built-in everything works alright.
>
> Which is the difference between calling Insert_Record and directly
> doing the insert statement?
> Which code should I add to the insert to avoid the error message?
>
> Thanks in advance,
> Jordi.

Not 100% sure, but I would always use the insert_record built-in rather than manually making an insert statement yourself. I'm guessing that the insert_record built-in also probably resets the internal flags for row status, block status, etc. whereas a manual insert probably doesn't.

-Matt Received on Wed Aug 23 2000 - 05:57:39 CEST