not matches in a construct clause

hi everybody a sql like select * from table_name wherefield_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...@serendipita.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@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Juanito Sent: 04 January 2008 13:06 To: informix-list@iiug.org Subject: not matches in a construct clause hi everybody a sql like select * from table_name wherefield_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@iiug.org http://www.iiug.org/mailman/listinfo/informix-list