Hi,
I would like to achive the following, but not sure how to do so....
Through some custom SQL I'm formatting a value. Now, the custom SQL for the formatting can consist of multiple components. Per component I have to store the type of component, the order + 1 or 2 additional values.
For example:
Type = Date, Order = 1 and value1 = dd-MM-yyyy
or
Type = FixedLengthSequence, order = 2, value1 = 0 and value2 = 15
Now, I prefer in this case not to store this info in multiple DB records. I was thinking about a virtual foundset and storing that virtual foundset into 1 field in a DB record.
Is something like this possible? Offcourse I need to be able to display this virtual foundset to the user and he/she needs to be able to edit it.
I do not think functionality like this is present in Servoy currently, but I hope someone will prove me wrong
Paul