SetFilter criteria with NULL 1

[abhijit74]

Hi Folks,
I want to use SetFilter function of the datawindow to specify a condition. The condition is that column value should be equal to a null.

Please help me.

Regards,
Abhijit

 

[PowerObject]

dw.SetFilter( &quot;<col> is NULL&quot; )
dw.Filter()

---
PowerObject!
-----------------------------------------

http://Groups.Yahoo.com/group/PowerObject

PowerBuilder / PFC Developers' Group

 

[abhijit74]

Hey PowerObject,
I tried doing exactly the same thing
I did this dw.SetFilter(&quot;Col1 IS NULL and Col2 <> 'N')

However I observed that it gave me a datawindow &quot;invalid function error&quot;

I am using 6.5

Cheers!
Abhijit

 

[PowerObject]

Abhijit,

This should work:

dw.SetFilter( &quot;IsNull( col1 ) and col2 <> 'N'&quot; )
dw.Filter()

Just let us know if it did...

---
PowerObject!
-----------------------------------------

http://Groups.Yahoo.com/group/PowerObject

PowerBuilder / PFC Developers' Group