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.

asked 24 Aug '14, 18:08

Krapas's gravatar image

Krapas
1
accept rate: 0%


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

link

answered 25 Aug '14, 02:31

Yalim%20Gerger's gravatar image

Yalim Gerger ♦♦
1.8k5
accept rate: 15%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×85
×12
×7

Asked: 24 Aug '14, 18:08

Seen: 966 times

Last updated: 25 Aug '14, 02:31


© Copyright Gerger 2017