Refresh Servoy after create table with Rawsql

Classic Servoy
1

Hi,

When I create a table with plugin Rawsql, and tried to use this table, servoy told me doesn’t exist. Is there anyway to avoid use this table without restart neither aplication or server.

Thanks
JC

2

Did you perform a flush?

3

Thank for your answer Marcel,

Yes, we did perform a flush without succesfull.

In our system, the user can create new tables but in order to the system could see this new table is necessary make a shutdown and restart servoy server. We can stop the system, to do this. Is there any other way?

thank you,
JC

4

Servoy loads all table information on startup. So I’d say there is no other way.

5

Try a table name starting with ‘temp_’, Servoy may discover that table dynamically.

Rob

6

I’ll be curious to hear if that works. Is that a supported feature?

7

Yes.

Rob