set table dynamically

Classic Servoy
1

Hi

Is it possible to set the table, a form is based on, dynamically, from within a method (instead from within the properties list)?

Thanks and regards

Birgit Rieder

7r gmbh
lindenplatz 12b
8203 schaffhausen
switzerland

2

Hi Birgit, the word dynamically pops up again :)

Maybe it is better to explain what you are trying to archieve so we can give a better answer…

3

Hello Marcel

Yes the world is dynamic (or I try to make it dynamic) :wink:

The main goal of this “dynamic” stuff is to reduce the number of forms in our solutions. Whenever I identify similar forms, I try to only hard code as less as possible and define the rest (the part which is always the same) at runtime (this is what I call dynamic).

Imagine a menu where the user chooses a topic. According to this topic I’d like to add a form to a tabless tab panel and define the table. This form always contains a list where the user selects e.g. a person or a product or…
I’d like to define the whole form anly once for all possible lists.

Thanks for your help and your ideas. Best regards

Birgit Rieder

7r gmbh
lindenplatz 12b
8203 schaffhausen
switzerland

4

birgit:
The main goal of this “dynamic” stuff is to reduce the number of forms in our solutions.

Be sure to see Adrian McGilly’s “Dynamic Valuelists Without Any Coding” at: http://www.servoymagazine.com

Dean Westover

5

Hi Birgit,

Have you considered using HTML to return your dynamic lists

You are in control of your SQL query and return of data which you can then format as HTML table and display in a HTML field.

The table which the form is based on becomes less important as all your data will simply be in a field which could be global and set to displayType HTML !?

The HTML can contain links which then fire further methods based upon your next/follow on process

This may not get you completely to your required end product but may assist or at least give you another perspective

Cheers
Harry

6

Hi Birgit,

I go with Harry. Example: I have several planning views I need to create. These views are all based on html. To be in control and to avoid too many forms for similar tasks. You can get the data you want to use in different ways e.g. use a dataset/sql statement or foundset.

The same is applicable for a valuelist. These can be set from a method based on 1 or 2 arrays you can get from a dataset or create yourself.

Hope this helps a little

7

Thank you all for the ideas! I’ll have to try it to see how it is done and if it works.

Best Regards

Birgit Rieder

7r gmbh
lindenplatz 12b
8203 schaffhausen
switzerland