Home » Developer & Programmer » Application Express & MOD_PLSQL » How to populate other text item without another button (Oracle 10G Apex 3.0)
How to populate other text item without another button [message #311584] Fri, 04 April 2008 20:32 Go to next message
dr.s.raghunathan
Messages: 539
Registered: February 2008
Senior Member
hi

I create Page no 14 where in two text item created such as
p14_id_no and p14_name. As soon as i enter value in
p14_id_no, querry should fire as "Select name into p14_name from
emp where id_no = p14_id_no".
In otherwise based on text item when i enter, immediately
all other items should get populated using some querry.

This can be achieved through button where i can attach querry.
But i do not want it. I want to achieve through computation.
While using computation it is giving option before header,
after header,on load etc.

i am confused.. please help me.

i am using my fathers id

yours
r.anugraha
Re: How to populate other text item without another button [message #312006 is a reply to message #311584] Mon, 07 April 2008 13:59 Go to previous messageGo to next message
andrew again
Messages: 2574
Registered: March 2000
Senior Member
see the many AJAX examples on http://forums.oracle.com/forums/forum.jspa?forumID=137

This is one of the references.

http://htmldb.oracle.com/pls/otn/f?p=11933:5
Re: How to populate other text item without another button [message #312554 is a reply to message #312006] Wed, 09 April 2008 04:21 Go to previous messageGo to next message
dr.s.raghunathan
Messages: 539
Registered: February 2008
Senior Member
thanks uncle
yours
r.anugraha
d/o dr.s.raghunathan
Re: How to populate other text item without another button [message #312601 is a reply to message #312554] Wed, 09 April 2008 07:11 Go to previous messageGo to next message
Littlefoot
Messages: 18819
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
uncle?!? ./fa/1600/0/

Not that it matters, but - what is what in
Quote:
r.anugraha
d/o dr.s.raghunathan

i.e. what is "r.", what is "anugraha", what is "d/o", I guess "dr.s.raghunathan" is you nickname on OraFAQ Forum but what are "dr.", "s." and "raghunathan"). I'm completely confused, as the only two words I understood were "thanks" and "yours". (Obviously, I'm not very smart).
Re: How to populate other text item without another button [message #312902 is a reply to message #312601] Thu, 10 April 2008 01:30 Go to previous messageGo to next message
dr.s.raghunathan
Messages: 539
Registered: February 2008
Senior Member
dear uncle,

i am school final girl.
My father name dr.s.raghunathan here dr means doctorate
s means my fathers father name sowrirajan
d/o means daughter of
uncle means -- we use to addresss the elder as brother or
uncle.
so far i moved or dealt with indian counterpart not to the
foreign personalities.

i am extremely sorry for the created confusion and the poor
english

i will slowly understand and try to adopt myself to the other
part of world.

anyway thanks for the suggestion you offered. But still
i am unable to make out the solution even after visiting the
specified sites. Hope it may take some more time to
familiarize since lots of jargon under the name of htmldb.

i will learn one day.

yours
raghunathan anugraha
daughter of dr.s.raghunathan
Re: How to populate other text item without another button [message #312973 is a reply to message #312902] Thu, 10 April 2008 04:32 Go to previous messageGo to next message
Littlefoot
Messages: 18819
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Thank you for the explanation!

If I understood you correctly, your first name is Anugraha, and your last name is Raghunathan.
Dr. Sowrirajan Raghunathan appears to be your father.
Right?

Out of curiosity - why did you choose to use your father's name instead your own?

Finally, there's nothing wrong with your English; after all, it is a foreign language for most of us. I didn't know that uncle or brother are used in such a way in India. So - today I have learnt something new!

Unfortunately, I can't help you with your problem. Terribly sorry.
Re: How to populate other text item without another button [message #313579 is a reply to message #311584] Sun, 13 April 2008 19:03 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Isn't there a trigger equivalent to Forms' When-Validate-Item. This trigger only fires when the contents of the field/item is changed.

In it, run your 'select' statement to populate the next field. I believe this logic is quite common in the various tutorials available with APEX and also in the Oracle Magazine examples.

David
Re: How to populate other text item without another button [message #313733 is a reply to message #313579] Mon, 14 April 2008 06:31 Go to previous message
dr.s.raghunathan
Messages: 539
Registered: February 2008
Senior Member
yes
conceptually and logically i am also with your views.
still i am tracing to locate the solution
yours
dr.s.raghunathan
Previous Topic: How to change the Password expiry time?
Next Topic: colour change of button
Goto Forum:
  


Current Time: Wed Apr 16 01:16:56 CDT 2014

Total time taken to generate the page: 0.11405 seconds