QUIZ truncation vs varchar

[Pickering, John (NORBORD)]

How about ...

>report account_no pic "'^^^^^^'" significance 8

That's a pair of double quotes around the whole picture with the pair of
single quotes inside them and part of the picture. You'll need to specify
the significance to include all 8 characters of the picture format -- i.e. 6
for your account number and 2 more for the single quotes..

The rest of you should stop fighting the tools and let Quiz do the work!

Regards,
JWP

-----Original Message-----
From: fernando.olmos at hpa.com.au [mailto:fernando.olmos at hpa.com.au]
Sent: Tuesday, September 06, 2005 9:31 PM
To: powerh-l at lists.sowder.com
Subject: QUIZ truncation vs varchar


Hi again gang.

Here is a tricky one...

I have a program is I am trying to get it to report some string chars
with a numeric value and have the numeric value enclosed in single quote
chars.

i.e.:	Account '123456' totals: ... blah blah blah

The blahs are the columns I am reporting, which is not the problem.

The problem I am having is how to actually print the account number
within the quotes, without QUIZ passing out the field.

This is what I am actually getting ...

	Account '  123456  ' total: ... etc

The 123456 value comes from an Integer size 4 with a pic "^^^^^^".

I tried simply saying trunc(accountno) in the report item, but QUIZ
rejects putting functions into report items, something which is really
annoying.

I also tried a define with a varchar * 6 to see if the varchar would by
default trim off the spaces. It made no difference.

Something in QUIZ is telling it to put the spaces between the single
quote chars.

Any help appreciated.

Thanks