Hi all,

When running this sql against an FM 6 database, the application
performing the query just exits. No error codes or anything. It
doesn't matter if its my .Net application or Microsofts query tool.
Any ideas?

Select *
from Table
where Col1 = 'Value A' OR Col1 = 'Value B'

It supports the AND in the where clause, but not OR??

Thanks
Andy

Found the solution..

You have to wrap each part of the OR in parans...like so

SELECT *
FROM TABLE
WHERE ( ID = 235 ) OR ( ID = 234 )

Otherwise the driver will crash (bleck).

andy

Actually that didn't fix it.. well it did in MS Query, but not my
application. Huh?