topic Re: Custom Table - New Field in Application Development and Automation Discussions

Custom Table - New Field

Former Member — Fri, 17 Oct 2008 17:59:09 GMT

Added SPART in a custom table , I am trying to retrieve an entry from that table where SPART is SPACE. This works fine in DEV, in Q system the select does not work.. What could be the reason ?

Re: Custom Table - New Field

Former Member — Fri, 17 Oct 2008 18:06:40 GMT

What do you mean 'does not work'? Does it dump, give an error message, a return code??

Rob

Re: Custom Table - New Field

Former Member — Fri, 17 Oct 2008 18:23:02 GMT

The query does not return a record when there are many records with SPART = SPACE

Re: Custom Table - New Field

Former Member — Fri, 17 Oct 2008 18:28:27 GMT

What does the data look like in SE16?

Rob

Re: Custom Table - New Field

Former Member — Sat, 18 Oct 2008 18:11:06 GMT

Hi,

Share the Query Please....

Re: Custom Table - New Field

Former Member — Mon, 20 Oct 2008 05:55:17 GMT

Hi sridhar,

Chek if there is any data for SPART in your custom table in Q system...

-Goodluck,

Bhumika

Re: Custom Table - New Field

christine_evans — Mon, 20 Oct 2008 09:53:39 GMT


> Added SPART in a custom table , I am trying to retrieve an entry from that table where SPART is SPACE. This works fine in DEV, in Q system the select does not work.. What could be the reason ?

Are you sure that SPART = SPACE? I've noticed before that when you add a new character field to an existing table that already contains records, the default value for the new field on the existing records is NULL and not SPACE. Try replacing the = SPACE with IS NULL.

If this is the case, I think that if you update the record the default will then be changed from NULL to SPACE.

Re: Custom Table - New Field

Former Member — Mon, 20 Oct 2008 14:59:00 GMT

Hi Christine.. You have understood the problem perfectly... Thank you .. I have even tried with NULL, even that does not work, I mean it does not retrieve the record...Is it by any chance dependent on the database ? We are using Oracle... Just FYI... I have used the database utility and tried to adjust the table, I was hoping that would get in a space into SPART , even then no luck... Only way out that looked to me was getting the user to put a space into each of the record through SM30...

Re: Custom Table - New Field

christine_evans — Mon, 20 Oct 2008 15:26:35 GMT

It won't work if you put the word NULL into SE16 but it will work if you put SPART IS NULL in a SQL statement in a program - I'm not sure which you are doing.

You can avoid this problem if you tick the Initial Values box when you create the field in SE11.

Re: Custom Table - New Field

Former Member — Tue, 21 Oct 2008 01:11:09 GMT

Thank You Christine...That I guess would solve my problem...