Re: <No Subject Supplied>
Julio Cesar de Figueiredo schrieb:
> I need the CONSTRUCT make this select:
> SELECT * FROM tab WHERE col1 <> any_value AND col1 <> other_value
> -----------------------------^ -----------^ --------^
> -------------------------^ --------------------^>
As far as I understand it, you want to do something likecol1 NOT IN
(any_value,other_value)
right?
AFAIK there is a way to construct an IN clause, but no way to construct
a NOT
IN clause.
Workaround1: Is it possible for you to scan the string that is created
by construct
for col1 IN and replace it by col1 NOT IN?
> form:
>
> col1 [ ]
Workaround2: Add col1's to your form.
form:
col1(1) [ ]
col1(2) [ ]
I am really not sure, if the latter works, but the former should.
Regards,
Roland