Home » Developer & Programmer » Forms » forms execute_query (forms 10g)
forms execute_query [message #503381] Fri, 15 April 2011 02:43 Go to next message
jai_g
Messages: 23
Registered: July 2009
Location: India
Junior Member
I am using forms 10g.
After EXECUTE_QUERY, i am validating records. Only 50% of records getting validated. Again if i tried only 50% of records validating out of balance. Pl help me.
Re: forms execute_query [message #503382 is a reply to message #503381] Fri, 15 April 2011 02:45 Go to previous messageGo to next message
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
Senior Member
What do you mean by validating records?
Re: forms execute_query [message #503387 is a reply to message #503382] Fri, 15 April 2011 03:44 Go to previous messageGo to next message
jai_g
Messages: 23
Registered: July 2009
Location: India
Junior Member
some fields are validated with prceedures. file is uploaded.
  • Attachment: proceed.txt
    (Size: 1.42KB, Downloaded 1450 times)
Re: forms execute_query [message #503391 is a reply to message #503387] Fri, 15 April 2011 03:56 Go to previous messageGo to next message
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
Senior Member
Where is that code run from - what trigger?
What exactly do you think it should be doing?
What exactly is it actually doing?
Re: forms execute_query [message #503393 is a reply to message #503391] Fri, 15 April 2011 04:01 Go to previous messageGo to next message
jai_g
Messages: 23
Registered: July 2009
Location: India
Junior Member
hi,
trigger is when_button_pressed.
If 50 records fetched then all the 50 records to vlaidated.
but it is validating only 25 records, and if again i try then another 13 records getting validated.
Re: forms execute_query [message #503396 is a reply to message #503393] Fri, 15 April 2011 04:24 Go to previous messageGo to next message
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
Senior Member
I would have thought your code would infinite loop personally.
There's nothing in the loop to make it change records (like next_Record) so it should just stay on the first one forever.
Are you sure that's the complete code?
Re: forms execute_query [message #503402 is a reply to message #503396] Fri, 15 April 2011 05:33 Go to previous message
jai_g
Messages: 23
Registered: July 2009
Location: India
Junior Member
No it is part of code, i came to know in between the other code i had used DOWN, hence it was moved 3 record. It was my mistake. Thanks for sparing much time for me.
Previous Topic: Please Suggest
Next Topic: how to dynamically make visible true or false in menu
Goto Forum:
  


Current Time: Mon Sep 16 13:08:21 CDT 2024