Results 1 to 2 of 2

Thread: Frm-40654

  1. #1
    Join Date
    Nov 2003
    Posts
    10

    Question Unanswered: Frm-40654

    I have a form where I handle inserts in the on-insert
    trigger. whenever I save a record and try to change a field afterwards, it gives the following error. It
    wouldn't let me make any changes.

    FRM-40654 record has been updated by another user. Re-query to see
    change.

    It seems to me that the trigger cannot commit the changes I make. I try
    to write commit_form but it didn't like it. Any suggestions to fix this.

    Thanks

  2. #2
    Join Date
    Aug 2003
    Posts
    40

    Re: Frm-40654

    What it looks like your trying to do is insert into another table at the
    same time as your form is writing to another table. Typically, for
    this type of action, a "pre" or "post" trigger is used (preferable in this
    case, a "post-insert" trigger.

    The "pre" is typically used to obtain other column values that you
    previously havent'y collected yet in the table your block will be
    writing to, such as the "key value" from a sequence.

    If you use a "post-insert" trigger, you may also want to post your
    results before you perform your insert. Then, if the post is successful,
    insert your results to the other table.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •