RE: JDBC columns blank

My best guess is that I've never tried this before:
myVar = *blank;
myVar += 'abc';


Thanks



-----Original Message-----
From: Buck Calabro [mailto:kc2hiz@xxxxxxxxx]
Sent: Monday, November 21, 2016 4:45 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: JDBC columns blank

On 11/21/2016 4:23 PM, Justin Taylor wrote:

I've spent two hours on this, and I figure it out five minutes after posting the question. I guess I just needed to spell out the problem.

The 'cardboard analyst' strikes again :-) http://imho.midrange.com/2005/12/18/cardboard-analyst/

I'm concatenating the column values together into a single varchar() variable. After each row is processed, I set the varchar() variable to blank (myVar = *blank;). Apparently that also pads myVar with blanks so the next time I try to append a new value (myVar += columnValue;) nothing happens. I can't believe I've never encountered this before.

I got burnt by this long ago, when varying was first introduced. Harsh lesson, but still never forgotten :-/

For those following along in the archives:

dcl-s thisVar varchar(25);
// load 25 blanks into thisVar
thisVar = *blanks;
// clear thisVar
thisVar = '';

--
--buck

Visit wiki.midrange.com and register for an account. Edit a page that helps you, and because it's public, you'll help someone else, too!