Re: ERROR #521: SQLError: SQLCODE = -400 %0ABMod+1^CacheSql9

[Ram�n Jim�nez]

I see you are manually constructing an SQL statement. Could it be the 
case that some statements are not valid? I.e. unbalanced quotes, invalid 
characters, etc. Is there a way you could print the generated SQL 
statement which produces the error?

Also as I said - take a look at the *actual* compiled code for the query 
which is where you are getting the error.

You could take a look at the release notes for the latest 4.1 kit(s), 
some SQL related issues are solved by the maintenance kits of that 
branch if memory serves me right.

HTH,
Ram�n
--
ZCacheLib - Open Source Extensions for Cach�
http://www.zcachelib.org