I have a "Database Query" element with the triggers "tableName" (datatype TEXT) and "parent_key" (datatype NUMBER).
The <SQL Statement> trigger is: "SELECT COUNT(id) FROM ${tableName} WHERE parent_key = ${parent_key}"
Tersus treats the Numbers as FLOATs and therefore I'm getting an error because parent_key is an INTEGER-column.
How can I pass the Number as INTEGER to the database with the "Database Query" template?
ciao, kkg
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