Updating DB structure when opening a solution

Classic Servoy
1

Hi:

If I have Servoy opened with a solution and I create a new column in the DB, I have to EXIT Servoy to update the column list in the Dataproviders window.

Servoy should update tables info when a opening a solution.

Log-Out
Bogota - Colombia

2

Hi Log-Out ,

Servoy developer is reading the database schema only once, at startup.
Tables and columns added via servoy are usable without restart.

Rob

3

But Serrvoy could read the DB schema at solution opening. Is it very difficult to implement?

Log-Out
Bogota - Colombia

4

Hi Log-Out,

You are assuming that a database connection is linked to a single solution.
Any solution can use any database connection. So lets say you have 2 solutions on your server that use the same database connection.
Solution 1 gets opened by user 1, the database gets checked and user 1 is of working with it’s solution.
5 minutes later user 2 comes along and opens solution 2. So it checks the database and finds that you changed some columns and tables in the mean time.
This works out fine for user 2…but what will happen to the running solution of user 1?
As you can see…things get complicated when it does what you are proposing.

Just food for thought :)

5

Ok!! You’r right :lol:

Log-Out
Bogota - Colombia