Kbase 18185: Apptivity: How to select records w/ unknown ? value PROGRESS
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/13/1998 |
|
Apptivity: How to select records w/ unknown ? value PROGRESS
If you wish to code a data source in Apptivity to select records in a
PROGRESS database which contain the unknown value, ?, in a particular
field, you can use the following syntax:
Assume that the field which may contain a null value is
mydb.test.
To select all records for which mydb.test has the unknown
value, code the data source SQL as follows:
SELECT * FROM mydb.test test WHERE mydb.test is null
To select all records for which mydb.test does NOT contain
the unknown value, code the data source SQL as follows:
SELECT * FROM mydb.test test WHERE mydb.test is not null
The Apptivity query editor supplies buttons on the where tab
which will help in this task. One button labeled "is null" will
tack on the "is null" text for the WHERE clause. There is also
a button labeled "is not null" which behaves in a similar fashion.
UTF 8/13/98 Apptivity 2.1