Urgent Req - switchServer - Forms, Relations & Valuelists???

Classic Servoy
1

We are applying switchServer on login to our solution. Where ever we have getDatasetByQuery or where we would in tha past have used controller.getDataSource() we now use a global for the chosen server name and that process works very well.

However we still see that all ‘plain vanilla’ valulists are not being changed to the relevant server (those created on a form as a create valulist, and using the server and table selected at creation time). The data-source for the valulists remains on the original server.

Before we start to take our solution apart to see if we have any other errors can someone please define exactly how switchServer should work with regards to valulists and the data-sources of forms???

We are using dynamic valulists where they are appropriate in some areas but if we need to build them for every area we have a hefty task on our hands and probably weeks of work.

Very much appreciate feedback on this issue as its an urgent requirement for us now.

2

Hi,
when you switch server A to server B all the foundsets, valuelists, relations and getDataSetByQuery set on server A will be evaluated against server B.
The only thing that is not switched is RawSQL. Doublecheck your valuelists, they should work as expected, just be sure to switch server as early as possible (on startup or user login).

3

ngervasi:
Hi,
when you switch server A to server B all the foundsets, valuelists, relations and getDataSetByQuery set on server A will be evaluated against server B.
The only thing that is not switched is RawSQL. Doublecheck your valuelists, they should work as expected, just be sure to switch server as early as possible (on startup or user login).

Thanks Nicola (and for your post last week too BTW). Looks like we need to investigate further as it’s not appearing to do that - certainly on getDataSetByQuery!