> I think you have multiple issues with this SQL Statement.
I was wrong. I didn’t fully understand the SQL statement at the time of my last
reply, upon further inspection it seems the SQL is valid (apart from the
missing : in the variable reference).
There must be something else wrong, like using this statement inside of a SQL
function {fn} call for example. I think we are missing some context about how
you are using this method, because executing this code in a method by itself is
working in a sample database here.
-Tim
**********************************************************************
4D Internet Users Group (4D iNUG)
FAQ: http://lists.4d.com/faqnug.html
Archive: http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:[email protected]
**********************************************************************
