Subsummary broken if SQL query uses 'OR'

Classic Servoy
1

I am using a SQL query to load records into a form, then sorting the foundset by a subsummary’s break field. If the query looks like SELECT pk_field FROM db.table WHERE date >= '1/1/2005' AND date <= '1/2/2005' ORDER BY pk_field then the print preview looks correct. If the query looks like ```
SELECT pk_field FROM db.table WHERE date = ‘1/1/2005’ OR date = ‘1/2/2005’ ORDER BY pk_field

Steve in LA
2

If I change SELECT pk_field FROM db.table WHERE date = '1/1/2005' OR date = '1/2/2005' ORDER BY pk_field to ```
SELECT pk_field FROM db.table WHERE (date = ‘1/1/2005’ OR date = ‘1/2/2005’) ORDER BY pk_field

3

Don’t understand precisely your output but be aware that you should always enclose any SQL ‘OR’ statement in parentheses. It should just be automatic. You can get really unstuck with all kinds of nasty things if you forget sometimes :). It has certainly happened to me a number of times!