Ranged QBE

[WSW]

How can I (if can) write QBE query to get SELECT statement like:

select * from table where field between val1 and val2;

Is it possible?

 

[Marco Kalter]

Range queries are not possible with QBE, because QBE uses the values of the dataset fields in QBEMode to build the where-clause. Therefore, each field can have only one query criterion. Range queries have to be explicitly programmed.

------------------
Marco Kalter
Allround Automations

 

[DaveH]

BUT... as a feature request, perhaps you could allow for a parameter of comparison (i.e. =, >=,