Parameters passed to SQL cannot be used inside quotes.
To overcome this, you can "pre-process" your query (or filter) string using Miscellaneous/Create from Template (so that the actual string sent to sql has the parameter already replaced by value) or use an alternate query such as the one suggested by JP in http://www.tersus.com/#Id=882.
Regards,
David
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