Hi ...
In the readme.txt freadt mentions that IN(?,?) statements in prepared statements are broken.
I can't find anything about in the bug tracker, but I seem to have trouble with all kind of subqueries in prepared statement in APLHA_O
e.g.
I have a lot stuff like
UPDATE a SET a.b=0 where a.c>(select MIN(d) FROM a WHERE e=X)
or alike:
When I execute the stuff interactively it works find but whe X is set as a parameter in a prepared statement I often get
'Single value expected'
What seems to be the problem ?
Cheers
S.,
-- ********************************** Dr. Sebastian Kloska Head of Bioinformatics Scienion AG Volmerstr. 7a 12489 Berlin phone: +49-(30)-6392-1708 fax: +49-(30)-6392-1701 http://www.scienion.de **********************************
------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ hsqldb-developers mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hsqldb-developers