Home » Developer & Programmer » Forms » CAN I USE 60 DIFFERENT VIEWS IN ONE BLOCK DYNAMICALLY?
CAN I USE 60 DIFFERENT VIEWS IN ONE BLOCK DYNAMICALLY? [message #238118] Wed, 16 May 2007 14:27 Go to next message
jtc103
Messages: 19
Registered: May 2007
Junior Member
I am new at using forms, and what I want to do is have a selection block and based on the selection, I need to generate the view name that I need to use for the detailed block.

So for example, based on my selection block of:

Source: A
Year: 2005

I will need to use A_2005_VW view.

The tricky part is, the 60 views would have different columns.

I was able to use query_data_source_name to open the view dynamically, but I don't know to do this for 60 different views with different column names to display.

Please help!

Thanks.
Re: CAN I USE 60 DIFFERENT VIEWS IN ONE BLOCK DYNAMICALLY? [message #238939 is a reply to message #238118] Mon, 21 May 2007 01:04 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have the same names eg item01, item02, item03, and when they don't exist 'select' a 'null' entry and give it an 'alias' of 'item03', for example.

David
Previous Topic: Content canvas with tabs
Next Topic: mail merge with Oracle forms and Word
Goto Forum:
  


Current Time: Mon Dec 05 04:52:25 CST 2016

Total time taken to generate the page: 0.12510 seconds