Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Charlene C. — — source: Informix-list mailing list archive (1991-1998)
I would like to write a report and order the information by the outcome
of an if statement.
example:
There are 4 hearing date fields.
In the body of the report program I would say:
if ba_hear4 is not null then
let u_hearing = ba_hear4
else
if ba_hear4 is null and ba_hear3 is not null then
let u_hearing = ba_hear3
else
if ba_hear3 is null and ba_hear2 is not null then
let u_hearing = ba_hear2
else
if ba_hear2 is null and ba_hear1 is not null then
let u_hearing = ba_hear1
NOW:
I want to order the report by
u_hearing
Any ideas?
Your privacy choices
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.