using SQL IN Statement with stringfields does not work in combination with any other selection argument
Posted: Fri 16 Dec 2005 08:59
select * from aTable where StringField in ('string1', 'string2')
works fine, however
select * from aTable where StringField in ('string1', 'string2')
and AnyField = 0
does not work. In fact anything you do beside the 'IN' selection breaks the SQL statement.
Couple of things i concluded:
- The bug seems to be dBExpress only, BDE or SQL+ clients process it fine
- The bug is also present using the SQLDriver, it is not database dependend
works fine, however
select * from aTable where StringField in ('string1', 'string2')
and AnyField = 0
does not work. In fact anything you do beside the 'IN' selection breaks the SQL statement.
Couple of things i concluded:
- The bug seems to be dBExpress only, BDE or SQL+ clients process it fine
- The bug is also present using the SQLDriver, it is not database dependend