Home » Developer & Programmer » Forms » forms 9i - Getting data into non base table items
forms 9i - Getting data into non base table items [message #125440] Sat, 25 June 2005 06:08 Go to next message
nriv
Messages: 5
Registered: June 2005
Location: Dublin
Junior Member
I have a block with 10 rows display ... I have customer_id as a base item but not customer_name .. How can I get the customer_name from customer_master table when the query is executed .
I know I need to write SELECT statement but can't figure out where to write the code.
Please advice

Report message to a moderator

Re: forms 9i - Getting data into non base table items [message #125485 is a reply to message #125440] Sun, 26 June 2005 20:50 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Use the Post-Query trigger on your block.

David

Report message to a moderator

Re: forms 9i - Getting data into non base table items [message #125565 is a reply to message #125485] Mon, 27 June 2005 12:41 Go to previous message
nriv
Messages: 5
Registered: June 2005
Location: Dublin
Junior Member
Thanks David .. I will try that.

Report message to a moderator

Previous Topic: Problem in accessing sequence.nextval in forms 6i,Database 10g
Next Topic: Connecting Forms 5i with Oracle 9i
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 01:22:40 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.