Hi,
I have two questions about using the find template to gather data from a postgresql database. I'm using database with a schema called "chains" and a table called "Properties" in my application. If I use the find template tersus generates this query:SELECT id, name, parentKey, dataTypeKey, unit FROM PropertiesBut it has to look like this:SELECT id, name, "parentKey", "dataTypeKey", unit FROM "chains"."Properties"In postgresql any database object (tablename, rowname, ...), that contains uppercase letters has to be encapsulated by quotation marks ("). Do i have to set a special parameter in my Configuration.xml for that?Any idea why the schema is not used in the query? The schema property of the database record template in my application is set to "chains".
Regards,Jan
To use the full functionality of this web site, JavaScript needs to be turned on.
For best results, use the Firefox browser..
Copyright © 2003-2017 - Tersus Software Ltd., All rights reserved. Terms of Use License Graphic design by EmaraDesign