Storing arrays as globals

Classic Servoy
21

Let’s say the lists are specific to given users. I guess you could store user:listname pairs, but that feels pretty kludgy.

22

Wow! :lol: Never knew that!
Thanks!

23

i just would do this with a n-m table between user and tableX
Because that is what you really want/are doing..
You want a relation from user to the table.. So just do it the sql way.

but i would agree that servoy should support this a bit better so that you can create a N-M relation with a n-m table underneath it. And then you can set a checkbox on the form and if you select it a entry in the n-m table is created and deselect servoy wil delete it. But i haven’t figured it completely how this can work.

24

Automatic N-M table!

THAT would be nice!

25

It sure would!

26

JerryR:
Let’s say the lists are specific to given users. I guess you could store user:listname pairs, but that feels pretty kludgy.

So? Just store a list of the list names for that user. Pretty easy. So I have a list of:

Bob Mail 01
Bob Mail 02
My Special Mailing
Christmas Letters

etc

Then put that in a pop-up menu - with a “go” button next to it and perform the search based on the contents of that popup. SIMPLE.

OF COURSE it would be fantastic if we would provide that excellent functionality that Johan mentioned. BUT - you can accomplish what you need to do TODAY as well.

:D

27

This is how I do it. In fact I use this method to add even more characteristics to my contacts.
Like this:

+----------+       +------------------------+       +----------------+
| contacts |-|---O<| contact_characteristic |>O---|-| characteristic |
+----------+       +------------------------+       +----------------+

Hope this helps.