RE: [sqr-users] Using the LET functions Isnull or Nvl with CHARorVARCHAR database columns

["Bencke, Gina" <GinaBencke@forestcity.net>]

The problem I was running into was not only the ISNULL function, but in
the use of EDIT(ISNULL(&ENTITY), '09).  Once I made the following
changes my results were more acceptable.  However I still determined
that SQR can not truly distinguish between a column containing an empty
string and one containing a NULL value.  Obviously I can get around this
using the database function ISNULL instead of SQR's function so I shall
not dwell on this.  

However, can anyone explain why the below sections of code produce
different output???

Originally my code which I thought was printing the appropriate ISNULL
results was as follows:

let $line3 = 'isnull(&ENTITY) expected: 01            actual: <' ||
edit(isnull(&ENTITY), '09') || '>'
print $line3 (+1,1)
Result  "isnull(&ENTITY) expected: 01            actual: <00>"

After receiving 'the dragons' email I suspect the edit function was not
working as expected and changed it to:
let #null = isnull(&ENTITY)
let $line3 = 'isnull(&ENTITY) expected: 01            actual: <' ||
edit(#null, '09') || '>'
print $line3 (+1,1)
Result "isnull(&ENTITY) expected: 01            actual: <01>"


Btw - We are using some tables that are not created in PeopleSoft and
thus may contain NULL values.


Gina Bencke
Bencke Consulting Corporation

Office (440) 519-0060
email: gina.work@bencke.com


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users