Hi,
I'm using Database Query. I can't use something like:
WHERE NVL(${varible}, TABLE.COLUMN) = TABLE.COLUMN ?
Doing this, passing a NULL value is equivalent to remove the condition.
Currently, I'm make this: Put a Exist (Collections/Exist) If Yes, pass the value, is No, pass a default value that don't exist in the DB (for Number, I pass a -1) and do the query:
WHERE ${var} = table.column OR ${var} = -1.
Do you have a better solution?
in my project, the queries are in a extern file, and we catch than there, so make something dynamically implies having a part of the query in File and another in Tersus and we are trying to avoid this.
Tks a lot
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