RE: varchar-variable in IF-statement not equals ""

why don't you try:
 
IF r_ppsonderzoek.string1 IS NOT NULL AND 

           r_ppsonderzoek.string1 > " " THEN

 

I believe it will work...

Best regards

Nuno

 

 

-----Mensagem original-----
De: Nanno Scheringa [mailto:[email protected]]
Enviada: terça-feira, 24 de Maio de 2005 15:40
Para: [email protected]
Assunto: [fourjs-users] varchar-variable in IF-statement not equals ""



Hi list,

 

The following IF-statement evaluates to false.

 

        IF r_ppsonderzoek.string1 IS NOT NULL AND

           r_ppsonderzoek.string1 <> "" THEN

 

When I take a look in the debugger 

r_ppsonderzoek.string1 = "Fy(a)"

 

The variable is part of an record. The record is defined like a table. In the table the field string1 is a varchar(100,0)

 

My runner:

nscherin # fglrun -V

Four J's Dynamic Virtual Machine Version 3.53.02.24

Built May 14 2003 17:36:58

(c) 1989-2003 Four J's Development Tools

Language support library: INFORMIX GLS

Database front end : INFORMIX-ESQL VERSION 9.14(a)

 

Our database:

nscherin # oninit -V

IBM Informix Dynamic Server Version 9.40.FC2     Software Serial Number AAA#B000000

 Fri May 30 00:57:33 CDT 2003

 

Does anyone know what's wrong. Im my opion the IF statement should evaluate to true. I don't know what I'm missing.

 

Regards,

Nanno Scheringa

Ensemble B.V.
Postbus 419
2700 AK Zoetermeer

tel:  079-3430435
fax: 079-3430456
http://www.ensemble.nl/
mailto:[email protected]