Re: <No Subject Supplied>
Julio Cesar de Figueiredo wrote:
>
> I need the CONSTRUCT make this select:
> SELECT * FROM tab WHERE col1 <> any_value AND col1 <> other_value
> -----------------------------^ -----------^ --------^
> -------------------------^ --------------------^>
> form:
>
> col1 [ ]
Unfortunately you can't do that.
You could have two fields in your form, like so:
> form:
>
> col1 [<>any_value ]
> col1 [<>other_value ]
However, the second field would require a different name and require
you to massage the resultant where clause string.
Another solution is to use INPUT ARRAY to input a list of values which
are then used to manually build the where clause.
Hope that helps,
--
Mark.
+----------------------------------------------------------+-----------+
|Mark D. Stock - Informix SA http://www.informix.com |//////// /|
|mailto:mdstock@informix.com FAQ http://www.iiug.org |///// / //|
| +-----------------------------------+//// / ///|
| Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////|
| Fax: +27 11 807 2594 |If it's fast, the users keep quiet.|// / /////|
|Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////|
+----------------------+-----------------------------------+-----------+