Re: FRM-40405 (Forms 5.0) ?

Mark Gumbs wrote:
>
> To suppress this message do a
>
> :system.message_level := 5;
>
> before your commit and set it back to 0 after.
>
> You say you are calling this form using open_form. Bear in mind that if you
> have any changes in your calling form, this will be saved when you press F10
> from your called form. I'm not sure if you deliberately wanted this
> functionality or not though.
> This may partly explain why you only get this problem when you use the
> open_form built-in.

If you don't want to commit changes in the calling form by pressing F10 in the called form, you can use OPEN_FORM with SESSION parameter to open new database connection in the called form.

>
> HTH
>
> Mark
>
> Ole Bredesen-Vestby wrote in message <37608902.2822718_at_news.eunet.no>...
> >Hi,
> >
> >I've got a form with 2 database-blocks. When I changes a value in one
> >of the blocks, commits (F10), its ok. Then I change it again, commits,
> >and now I got this message: "FRM-40405: No changes to apply" popping
> >up on the other block in that form. I don't want this message.
> >
> >I've tried writing ON-MESSAGE triggers both on the form-level and the
> >block levels to trap this message, but it seems to be triggered
> >somewhere else.
> >
> >The strange thing is; this only occurs if I open this form from
> >another form, using open_form('my_form').
> >
> >Any ideas ??
> >
> >- Ole BV
> >

-- 
Valeri Sorokine
ProSoft, Russia, Moscow, Information Systems Division
Phone: +7 (095) 234 0636 (6 lines) FAX: +7 (095) 234 0640
E-mail: vsorokin_at_dd.ru OR vsorokin_at_prosoft.ru
http://www.dd.ru