Re: SQL-Statement problem

[Jeff Zucker]

Walter B. Takens wrote:

Dear all

i am having a problem with SQL-Statement-1.005, whereas SQL-Statement-0.1020 is working fine.

SELECT KOLOM1,KOLOM8,KOLOM5,KOLOM6,KOLOM7 FROM MYTABLE
WHERE ( ( ( ( KOLOM4 = '123456' OR KOLOM4 = '' ) AND KOLOM3 = '127' ) OR KOLOM8 = 'TRUE' ) AND KOLOM1 = 'bla' )

Yes, sorry, there are two bugs in SQL::Statement that are biting you there, I am working on both. The first is the = '' construction -- the parser gets confused by that. The second is the unecessary (but quite valid) enclosing of the WHERE clause in outer parens. Sorry, there is no quick fix, I'll try for a new release as soon as I can.

--
Jeff