OraFAQ Forum: Forms » Post Query freezing forms

Home » Developer & Programmer » Forms » Post Query freezing forms (Oracle Forms 11g, Windows 7, Oracle Weblogic 11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Post Query freezing forms [message #650207]

Tue, 19 April 2016 09:39

lakemichigan2
Messages: 6
Registered: October 2015

Junior Member

Hello,

I'm having trouble with some non-database items on my form. When I'm at the first record and I press the key up button on the keyboard in a non-database text item, my forms just freezes on the web. For the database text items, I get the 'FRM-40100: at first record' error when I press key up on the text item. I want the same error for the non-database text items instead of the form freezing. Is there any way i can fix this?

Any help would be great. Thank you.

Report message to a moderator

Re: Post Query freezing forms [message #650209 is a reply to message #650207]

Tue, 19 April 2016 10:22

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

What happens if you "trap" it with a KEY-UP (block level) trigger, such as

if :system.trigger_record = 1 then
   message('At first record');
   raise form_trigger_failure;
else
   previous_record;
end if;

Alternatively, instead of the PREVIOUS_RECORD, try the UP built-in.

Report message to a moderator

Re: Post Query freezing forms [message #650210 is a reply to message #650209]

Tue, 19 April 2016 11:42

lakemichigan2
Messages: 6
Registered: October 2015

Junior Member

Thank you very much, they both worked on my form.

I'm getting the same freezing issue when I press key down the last record. Would I use the DOWN built-in for that?

This is a key-down trigger I tried:

if :system.trigger_record <> 1 then
   message('At Last record');
   raise form_trigger_failure;
else
   DOWN;
end if;

I tried this, but i wasn't going further than the second record when pressing key down.

Report message to a moderator

Re: Post Query freezing forms [message #650221 is a reply to message #650210]

Tue, 19 April 2016 23:57

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

It is a different system variable:

if :system.last_record = 'TRUE' then
   message('At last record');
   ...

[Updated on: Tue, 19 April 2016 23:57]

Report message to a moderator

Re: Post Query freezing forms [message #650286 is a reply to message #650221]

Thu, 21 April 2016 09:22

lakemichigan2
Messages: 6
Registered: October 2015

Junior Member

That resolved my issue with that form. I used the DOWN built-in in the else condition. Thank you helping me.

Report message to a moderator

Re: Post Query freezing forms [message #650293 is a reply to message #650286]

Thu, 21 April 2016 16:09

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

OK; though, it was the :SYSTEM.LAST_RECORD, not the DOWN built-in which fixed the problem.

Report message to a moderator

Previous Topic:	oracle forms 11gR2 with SSO
Next Topic:	FRM-41213 unable to connect to the report server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 04:56:16 CST 2025