FRM-40501 (Solution Required)
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: FRM-40501 (Solution Required)

  1. #1
    Join Date
    May 2001
    Location
    Boston
    Posts
    24

    Thumbs up

    Hi,

    Let me explain the scenario of what i am doing

    I have 2 blocks.

    DataBlock & control block with only one field and a 'Update All' push button.

    When I enter any value in the Control Block field and press the push button it should update all the records in the Data block column value with Control Block value.

    Going to the scenario

    STEP 1) 'USER A' runs the form and queries for all the records.
    STEP 2) He then changes one of the column value in the data block

    STEP3) 'USER B' runs the same form and queries for all the records.
    STEP4) When enters some value in the control block field and presses the push button

    Gets the following error message 'FRM-40501' followed by
    'Could not resolve records (2 tries)'

    The above message is displayed for all the records in the main data block.

    So, can anyone please tell me a way to display the message only once and come out.

    I appreciate your help in advance.
    Thanks.
    RaviShankar.

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    Capture the error code in an on-error trigger and suppress it.

  3. #3
    Join Date
    Jun 2008
    Posts
    1
    select primary key field from datablock control and set primary key value to yes.

Posting Permissions

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


Click Here to Expand Forum to Full Width