Hi I have Temporary table, it never have same structure, and i want to create form to show and edit content of this table. It will be good to see an example. |
Hi Krapas, I guess if you can at least estimate the max number of columns in the temporary table there is a way. I'd create a temporary table with columns column1,column2,column3 etc… up to columnN. Similarly, I'd create a Datasource Definition with the SQL select * from my_temporary_table. I'd create a Grid which contains the N columns from the datasource definition. I'd hide/show the relevant Grid columns depending on the situation. I'd do the same for a Form based approach. If the potential column names of your temporary table is limited (say out of a pool of 30 potential column names), the whole thing becomes even easier. Then, instead of naming the columns in the temporary table column1,column2 etc… I could give the columns more meaningful names. Hope this helps. Kind Regards, Yalim |