not matches in a construct clause

hi everybody
a sql like

select * from table_name
where
field_name not matches "V*"

how can i put this condition in the run of a program made with construct by
name?

Thanks everybody

Juanito said:

hi everybody
a sql like

select * from table_name
where
field_name not matches "V*"

how can i put this condition in the run of a program made with construct
by
name?

It's been a long, long time, but something like

^V*

might work...

--
Bye now,
Obnoxio

"There were a myriad of problems which conspired to corrupt your reason
and rob you of your common sense. Fear got the best of you, and in your
panic you turned to the Labour Party. They promised you order, they
promised you peace, and all they demanded in return was your silent,
obedient consent."

--
This message has been scanned for viruses and
dangerous content by OpenProtect(http://www.openprotect.com), and is
believed to be clean.

On Jan 4, 1:29*pm, "Obnoxio The Clown" <obno... (AT) serendipita (DOT) com>
wrote:

Juanito said:

hi everybody
a sql like

select * from table_name
where
field_name not *matches "V*"

how can i put this condition in the run of a program made with construct
by
name?

It's been a long, long time, but something like

^V*

might work...

--
Bye now,
Obnoxio

"There were a myriad of problems which conspired to corrupt your reason
and rob you of your common sense. Fear got the best of you, and in your
panic you turned to the Labour Party. They promised you order, they
promised you peace, and all they demanded in return was your silent,
obedient consent."

--
This message has been scanned for viruses and
dangerous content by OpenProtect(http://www.openprotect.com), and is
believed to be clean.

http://publib.boulder.ibm.com/epubs/pdf/ct1vbna.pdf

4GL reference manual, Chapter 4 page 61

Caret. A caret ( ^ ) as the first character within the brackets
specifies
the logical complement of the set, and matches any character that is
not listed. For example, the search value [^AB]* specifies all strings
beginning with characters other than A or B.

So you may need to do [^V}*

When you do a CONSTRUCT BY NAME in Informix-4GL the system uses a form to
assist in generating a where clause for embedding into an SQL statement.
The Query by Example is very clever and recognises many of the regular
expressions including the squared-bracket notation. I know this includes [ ]
notation and I have always assumed that this is comprehensive. I have just
tried this on one of my systems and in the field concerned entered [^V]*
and that worked.

BTW this should also work in Informix-SQL forms.

Regards

Malcolm

-----Original Message-----
From: informix-list-bounces (AT) iiug (DOT) org [mailto:informix-list-bounces (AT) iiug (DOT) org]
On Behalf Of Juanito
Sent: 04 January 2008 13:06
To: informix-list (AT) iiug (DOT) org
Subject: not matches in a construct clause

hi everybody
a sql like

select * from table_name
where
field_name not matches "V*"

how can i put this condition in the run of a program made with construct by
name?

Thanks everybody


_______________________________________________
Informix-list mailing list
Informix-list (AT) iiug (DOT) org
http://www.iiug.org/mailman/listinfo/informix-list