Help with VARCHAR needed

[Chris Sharman]

leonard_berkowitz@harvardpilgrim.org wrote:
> HPe3000; Powerhouse 8.19C.
> 
> I have not used VARCHAR previously. I somehow believed that it was not
> available in my environment.
> 
> To parse a 256-byte field that has variable-length sub-fields within it, I
> am using VARCHAR. It seems-- in the DEFINE --  that I have to set VARCHAR *
> N or SIZE M to be the maximum expected length of the sub-field. I chose
> SIZE 20. When I report the DEFINEd items, they come out fixed width of 20.
> 
> So, how do I take advantage of the variable-length?

Is this Quiz ?
If you want to print something else immediately next to your varchar, I 
guess you need another define. Quiz pads everything to fixed width 
columns, except the last column. If you don't want that padding, you 
have to construct the line yourself in a define, then report the defined 
item. I've done that to take excess space out of html reports etc.

I've never found that varchar does anything different to truncate(char)
I haven't used it much. I have a vague recollection that it gets passed 
strangely (in Quick) or something.

Chris



-----------------------------------------------------------------------

Any views expressed in this message are those of the sender and not
necessarily those of CCA Group.  The unauthorized use, disclosure,
copying or alteration of this message is forbidden.  The contents of
this message may be confidential and/or privileged, copyright CCA Group
and are intended solely for the use of the individual or entity to whom
they are addressed.  Whilst this message has been scanned, CCA Group
cannot guarantee that it is virus free or compatible with your systems
and accepts no responsibility for any loss or damage arising from its
use. The recipient is advised to run their own anti-virus software. If
you receive this message in error please contact
postmaster@ccagroup.co.uk immediately, destroy any copies and delete it
from your computer systems.