topic Re: Set field value to null in Application Development and Automation Discussions

Set field value to null

Former Member — Fri, 10 Nov 2006 10:53:13 GMT

Hi - I have appended a single character flag field to table equi (using the append structure) - Using a select statement I can return all records where this field has nt been populated by using the select statement:

select * from equi where zz_flag is null

However if I populate the field BUT then want to return it to null I am unable to do so i.e.

update equi set zz_flag = null where zz_flag = 'X'

returns the error 'Field NULL is unknown' . Using CLEAR sets the field to an empty string. How do I set this field back to NULL? Thanks

Re: Set field value to null

Former Member — Fri, 10 Nov 2006 10:55:13 GMT

Try Using update equi set zz_flag = <b>' '</b> where zz_flag = 'X'.

Instead of null, give space in quotes.

Best Regards,

Vibha

*Please mark all the helpful answers

Re: Set field value to null

anversha_s — Fri, 10 Nov 2006 10:55:26 GMT

hi,

update equi set zz_flag = <b>space</b> where zz_flag = 'X'

rgds

Anver

Message was edited by:

Anversha s

Re: Set field value to null

Former Member — Fri, 10 Nov 2006 10:55:52 GMT

Give 'Null' in single quotes. May be u will get it.

Regards

Haritha

Re: Set field value to null

Former Member — Fri, 10 Nov 2006 10:56:15 GMT

hi,

update equi set zz_flag = ' ' where zz_flag = 'X'

Re: Set field value to null

Former Member — Fri, 10 Nov 2006 10:56:45 GMT

hi,

pls try in this way :

update equi set zz_flag = space where zz_flag = 'X'

Re: Set field value to null

Former Member — Fri, 10 Nov 2006 10:57:27 GMT

Hi,

u cant directly set the value for flag field as NULL as its taking only one char field

bcoz there is such kind of value NULL in SAP

either u set as ' ' .

Or difine the value range at domain level for flag field like ' ' for NULL and X for not NULL as giving the des NULL

Then u can try with

select * from equi where zz_flag = ' ' .

Regs

Manas Ranjan Panda