DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: forms troubles

  1. #1
    Join Date
    Apr 2006
    Posts
    9

    forms troubles

    hi,
    I've next problem:
    In a compilled form module when i press the button (which it should to return to me the result of my interogation) i'm obtaining next error message:
    frm-40735ra-04122:exact fetch returns more then requested number of rows.
    How do i treat this error in my internal code?
    the data stored in the interogation table excludes any duplicates.
    Thanks a lot!
    sorry for my english!

  2. #2
    Join Date
    Jul 2005
    Posts
    16
    U can use Following Code In Form level (ON-Error)Trigger

    BEGIN
    /*Put Error Message umber here*/
    IF ERROR_CODE = '40815' THEN
    NULL;
    ELSE
    MESSAGE (ERROR_CODE || ' ' || ERROR_TEXT);
    MESSAGE (' ');
    CLEAR_MESSAGE;
    END IF;

    END;

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