[FIXED] Client doesn't see current database info

(Sorry, I posted a message under the Web Client forum. I meant to post in this forum. Please delete my message from that forum.)

We’re getting a a ‘Could no load record’ error on our client when trying to view lists.

The error log in the server logs show that the client is doing a SELECT *, and then complaining about one of the fields not being there.

The thing is, that field has been moved to another table.

Why is it still showing up in a SELECT *, and how do we get the client to see the current database schema?

Thanks.

EDIT: Restarting the Servoy Application Server did the trick.

This goes for both, server and developer: If you manipulate the database from outside Servoy, a restart is required to let Servoy know. Table info is retrieved at the start of Servoy. This also goes for the situation that you use a developer to manipulate tables and have a server running. That server won’t notice this until restart.