Re: Can't RPG Update a NULL Field?

["Michael Ryan" <michaelrtr@xxxxxxxxx>]

Thanks Rob (and i5)...that was it.

"When a null-capable field is output to or updated in an externally
described database file, then if the field is null, the value placed
in the buffer will be ignored by data management."

On Feb 5, 2008 1:35 PM,  <rob@xxxxxxxxx> wrote:
> <snip>
> It wasn't until is set the fields that
> </snip>
> Bablefish had a tough time translating that.
> Did you read the RPG Reference on null handling at
> http://publib.boulder.ibm.com/infocenter/systems/scope/i5os/topic/rzasd/sc092508869.htm#bbnull
> and
> http://publib.boulder.ibm.com/infocenter/systems/scope/i5os/topic/rzasd/sc092508315.htm#usrnvs
> Namely, did you turn null off before attempting to change the value?
>
> Rob Berendt
> --
> Group Dekko Services, LLC
> Dept 01.073
> PO Box 2000
> Dock 108
> 6928N 400E
> Kendallville, IN 46755
> http://www.dekko.com
>
>
>
>
>
> "Michael Ryan" <michaelrtr@xxxxxxxxx>
> Sent by: midrange-l-bounces@xxxxxxxxxxxx
> 02/05/2008 01:26 PM
> Please respond to
> Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
>
>
> To
> "Midrange Systems Technical Discussion" <MIDRANGE-l@xxxxxxxxxxxx>
> cc
>
>
> Subject
> Can't RPG Update a NULL Field?
>
>
>
>
>
>
> Riddle me this...I was trying to update a record using the RPG UPDATE
> opcode. I first tried the %Fields parm (which I usually use), and the
> fields weren't being updated. So I took off the %Fields - no change. I
> had specified H AlwNull(*UsrCtl), which I thought would allow me to do
> as I pleased with a null field. It wasn't until is set the fields that
> I was trying to update to their default values (zeros, blanks) that I
> was able to programmatically update the fields that contained a null.
> Is this WAD or am I missing something? Thanks...
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.