topic Re: Null value in a select-option in Application Development and Automation Discussions

Null value in a select-option

Former Member — Tue, 28 Oct 2008 11:04:39 GMT

Hi all,

I have the follow question:

can I populate a range vith a null value?

I have a field in a standard table which can be "space" or "null". But if I insert:

sign = I

option = EQ

low = space

records with "null" field aren't extracted by the select statement. So is there any way to populate:

low = null or something similar?

Best Regards,

Raffaele Frattini

Former Member — Tue, 28 Oct 2008 11:14:28 GMT

you can try with the logic. appending a space to the select option will help you. populate the select-option in the initialization event and see.

Former Member — Tue, 28 Oct 2008 11:14:31 GMT

If the field is of type char then you need to wrte the same in quotes woth caps

else

declare

constants : c_null type i value '0'.

then assign the same

You check the null value using INITIAL laso.