Home » Developer & Programmer » Forms » Please help -- detail record
Please help -- detail record [message #519473] Fri, 12 August 2011 09:34 Go to next message
piyarustagi
Messages: 38
Registered: January 2011
Member

I have a field in a block called pnumber, and there's an LOV on it..

one pnumber has multiple strips.

What I want is that when I select a value from the lov...

all the strips of that pnumber should come up in a multiline block.

What I've done - I have created a detailed block of strips with strips as multi-line.
I'm trying to use cursor but something is going wrong and it thows error that fetching more than one row.

Please suggest something..
Re: Please help -- detail record [message #519474 is a reply to message #519473] Fri, 12 August 2011 09:39 Go to previous message
cookiemonster
Messages: 13937
Registered: September 2008
Location: Rainy Manchester
Senior Member
Why not use forms default processing?
Make both blocks database blocks, define a relationship between them, use execute_query.
Previous Topic: How to call a batch file existing in network path through oracle forms 6i
Next Topic: Individual Tab page bar color
Goto Forum:
  


Current Time: Sun Sep 08 23:01:12 CDT 2024