Home » Developer & Programmer » Forms » Post Query freezing forms (Oracle Forms 11g, Windows 7, Oracle Weblogic 11g)
Post Query freezing forms [message #650207] Tue, 19 April 2016 09:39 Go to next message
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.
Re: Post Query freezing forms [message #650209 is a reply to message #650207] Tue, 19 April 2016 10:22 Go to previous messageGo to next message
Littlefoot
Messages: 21677
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.
Re: Post Query freezing forms [message #650210 is a reply to message #650209] Tue, 19 April 2016 11:42 Go to previous messageGo to next message
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.
Re: Post Query freezing forms [message #650221 is a reply to message #650210] Tue, 19 April 2016 23:57 Go to previous messageGo to next message
Littlefoot
Messages: 21677
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 Go to previous messageGo to next message
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.
Re: Post Query freezing forms [message #650293 is a reply to message #650286] Thu, 21 April 2016 16:09 Go to previous message
Littlefoot
Messages: 21677
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.
Previous Topic: oracle forms 11gR2 with SSO
Next Topic: FRM-41213 unable to connect to the report server
Goto Forum:
  


Current Time: Fri Jun 18 06:20:37 CDT 2021