using SQL IN Statement with stringfields does not work in combination with any other selection argument

using SQL IN Statement with stringfields does not work in combination with any other selection argument

Postby praaphorst » 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
praaphorst
 
Posts: 5
Joined: Thu 08 Dec 2005 11:56
Location: The Netherlands

Return to dbExpress driver for Oracle