Re: Testing for no input with CONSTRUCT statement

}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>