| viewing data dynamically??question for Forms Gurus?? [message #146475] |
Thu, 10 November 2005 14:32  |
ramisy2k
Messages: 150
Registered: April 2005
|
Senior Member |
|
|
Hello gentlemen,
I have a application in 9i and Forms 6i, the main purpose of my programme for the end user is to extract the information from data stored in the different database. The user will not be able to add, delete or update the data but can only view the analysis and calculation on the data through queries in Forms and then save it into txt files directly from forms..(though he can not see the actual tables data as it is stored but only anylysis on it)
i have made some Forms based on VIEWS and thats fine
In one another Form, I have programmed such a funtionlaity by which end user will make his choices about the data he wants to view and Filter it using the criteria provided on the Form and then execute the query..
In other words the user will generate the query to be executed at run-time by passing global variables to the Form and then view the data..For this purpose I have made my Form (under discussion) on From Clause Block property..
Gentlemen,the problem is that in my (From Clause) Form has columns (items) created in layout editor which are only related to query being generated and executed at run-time so the user can only filter the column data but not the other columns he would like to see or not by generating another query
In my application the number of different types of queries generated at run time can be over 10,000 so I cannot make one Form each for each of those queries. That is why i have used 'From Clause property' in which the query is passed at run time and the data is viewed..but at it can only show the data about the columns which have been created in layout editor
I would like to have such a functionlity in my Form using which my Form is not only ONE query depenedent (or fixed number or columns dependent). But based on the query passed in the Form the user would be able to see any type of data from different columns in his query??
..my question is this how can I achieve this..? or waht whould i do to acheive this
I have heared that using Oracle Spread Table OCX feature in froms this can be done perhaps
I hope my question would be clear to all..
Note: all data will be based numeric, date or alphabetical characters only viewed in tablular for with 28 records)
regards.
[Updated on: Thu, 10 November 2005 14:34] Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Re: viewing data dynamically??question for Forms Gurus?? [message #147550 is a reply to message #146475] |
Fri, 18 November 2005 03:26  |
ramisy2k
Messages: 150
Registered: April 2005
|
Senior Member |
|
|
David, I dont have a View,
i have a Form with a From Clause Block...
I generate my query at run time by pasing global variables to the From Clause Block SELECT query in 'pre-query trigger'
and then the data is displayed in the Form..
the problem is that my Form is dependent only to the items created in layout editor but I want to make such a dynamic Form in which the columns are adjusted and shown accorddng to the query excecuted at run-time by passing global variables..
some times the query may be
SELECT COL1, COL1, COL1...COL10 FROM T
SOMETIMES
JUST
SELECT COL1, COL2, COL10 FROM T
AND SO. ON..
I HAVE heared that Oracle spread table can do that just like excel spread sheet when we pasted any type of data in excel the columns are created and adjuested according to the data pasted or inserted...
there is no certainty that which columns would be in every
query..as the query is genrated at runtime form all the db tables..
hope this will clear my problem...
[Updated on: Fri, 18 November 2005 03:31] Report message to a moderator |
|
|
|
| Re: viewing data dynamically??question for Forms Gurus?? [message #149769 is a reply to message #147550] |
Sun, 04 December 2005 22:33 |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
How about this? Create a block with nine items: item_1, item_2, item3, ... item_9.
Then do your query SELECT COL1 item_1,
COL1 item_2,
COL1 item_3,
...
COL10 item_9 FROM TSELECT COL1 item_1,
COL2 item_2,
COL10 item_3,
...
null item_9 FROM T
Please give feedback on this solution.
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
