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.
Jonathan Leffler — — source: Informix-list mailing list archive (1991-1998)
}From: Dave Snyder <dave@das13.snide.com>
}Subject: Re: Testing for no input with CONSTRUCT statement
}To: jh@cadre.com
}Date: Sun, 30 Jan 1994 11:23:27 -0500 (EST)
}Cc: informix-list@rmy.emory.edu (INFORMIX Mailing list)
}X-Informix-List-Id: <list.3426>
}In article <1994Jan28.201140.15960@fripp.ri.cadre.com> you write:
}} I had a situation where I wanted to prevent the users of a query screen from
}} simply hitting the escape key and selecting every row in a table. ...
}} the CONSTRUCT statement builds its where clause simply as "1=1" ...
}Why can't you replace the two lines (the <<<<< ones) with:
} IF where_part MATCHES "*1=1*" THEN
Or, even more simply:
IF where_part = " 1=1" THEN
Yours,
Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>
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.