Virtual foundsets...

Classic Servoy
1

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 :D

Paul

2

Hi Paul,

You CAN keep this info in a single record - then you would need to parse the data in there to break it out into multiple values for use in your other methods/sql.

Hope this helps,

Bob Cusick