Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Null value in a select-option

Former Member
0 Likes
1,323

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

2 REPLIES 2
Read only

Former Member
0 Likes
753

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.

Read only

Former Member
0 Likes
753

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.