I’m trying to use Servoy with the database Cache from Intersystems.
When I make a new form, Servoy retrieves the names of the tables of the database specified in the jdbc connection.
I can add the fields on the form but when I try to execute the form, I receive an error “Could not retrieve form data” and the details explain that “Table or View is not found”.
And yes, Servoy is trying to access the table without specifying the schema name.
Then , I try to modify the property of the table name to include the name of the schema but I receive another error saying “Cannot find table SchemaName.tableName (is undefined or missing) from server cacheServer”.
What can I do then?
I’ve used standard query tools (with jdbc connections) that are working very well with Cache.
Is it not possible to use schema name with Servoy?
Servoy is great but I need this connection with Cache!!!