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)

You say you have a view through which you can retrieve your data. Try a simple form based on that view and you get back the data that you want but, unfortunately, with data that you DON'T want to display. Is this correct?

Please explain how YOU will know which fields are to be shown to which user? Tell me how you will know and I will tell you how to display them.

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..

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...