|
NO Karen
I found the same thing when I upgraded a long time
6.1A client recently to 6.5++. There IS a difference
David
----- Original Message -----
Sent: Thursday, June 12, 2003 11:17
AM
Subject: [RBASE-L] - Difference in way
1.864 works
I upgraded a client to version 1.864 of RBWin from
the
early 1.842 that they were using and ran into a
difference in the
way the choose command works. I had a
menu like this:
CHOOSE vAsk FROM #VALUES FOR ( +
LJS(CompanyName,25)
& LJS(city,12) & LJS(State,4) ) +
FROM companies
WHERE .....
In version 1.842, if 'City' was null, it would preserve
the
space and the 'State' would appear in the last column under
the
other states.
But in version 1.864, if City is null but State is not,
it
moves the state over into the City column! Has anyone
else
noticed this? I tested this through version 1.851 and
it
operates the old way. So somewhere after 1.851...
So you
would have to test EVERY column that might be null
as follows. You'll
notice the period in the IFNULL formula;
if you put a space, it leaves out
anything that follows that
column, so you must apparently put a placeholder
in there of
some kind.
CHOOSE vAsk FROM #VALUES FOR (
+
LJS(CompanyName,25) +
& LJS(
IFNULL(def_value,'.',def_value),20) +
& LJS(State,4) )
+
FROM companies WHERE .....
I'd love to know I did
something wrong....
Karen
|
