Re: Can't RPG Update a NULL Field?

[vhamberg@xxxxxxxxxxx]

Because it is NULL, not blank - system does not know what to do with it. NULL means "unknown", "unknowable".

Twists one's mind a bit, eh?


 -------------- Original message ----------------------
From: "Michael Ryan" <michaelrtr@xxxxxxxxx>
> Yeah, and that would tell me if it had a null value, but I'm wondering
> why I can't update the fields.
>
> On Feb 5, 2008 1:28 PM, i5 <i5@xxxxxxxxx> wrote:
> > "
> > %nullind()  ?
> >
> >
> > ----- Original Message -----
> > From: Michael Ryan <michaelrtr@xxxxxxxxx>
> > To: Midrange Systems Technical Discussion <MIDRANGE-l@xxxxxxxxxxxx>
> > Cc:
> > Date: Tuesday, February 5 2008 07:26 PM
> > 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.
> -- 
> 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.