Re: Any problem with MESSAGE_CODE in FORMS 5.0 ??

Hello,

MESSAGE_CODE is set to the last message fired by Forms/Oracle e.g. 40301, the current value will set to another value only when the ON-MESSAGE-Trigger fires. (An succesfull Query returns no messages !!) So you can use MESSAGE_CODE outside ON-MESSAGE-Trigger e.g. in the EXEPCTION-Clause of a procedure or function ...

So try the following :

...

   execute_query;
...

if

   block_name.rowid is not null -- successfull query then

   go_item ( Block_name.fname );
else

   message ( 'Query retrieved No results.' );    go_item ( Block_name.lname );
end if;

Only valid when the Block based on a Table or View with an rowid !!

See also : SYSTEM.BLOCK_STATUS / SYSTEM.RECORD_STATUS

Hope that helps

Kiran Anumolu <anumolu_kiran_at_hotmail.com> schrieb in im Newsbeitrag: 388E03C3.24F6EC19_at_hotmail.com...
> ...
> if MESSAGE_CODE = 40301 then
> message('Query retrieved No results.')
> go_item(Block_name.fname);
> else
> go_item(Block_name.lname);
> ...
> Thanks.
>
>
>
>
> --kiran
> anumolu_kiran_at_hotmail.com
>
>
>
Received on Wed Jan 26 2000 - 04:46:15 CET