Re: 4GL question

Candy McCall wrote: > > Thanks! That worked and is a much better way. (I knew there > had to be a better way) > > Candy > -- > Candy McCall > ONLINE Computing, Inc. > (candym@olcinc.com) > > > Hi Candy, > > > > Have you tried to use the data type VARCHAR instead of CHAR ? As far > > as i know it only allocates the string you assign with no space, so you > > don't have to substring the remaining space. You can also use the same concept with CHAR, but I think VARCHAR is more appropriate here. You could probably check a warning flag in SQLCA to determine if the char was truncated as well, but I can't remember. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| | http://www.informix.com http://www.informixhandbook.com |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |This email will self-destruct in |/// / ////| | |10 sec. If you received this email |// / /////| | |in error, sorry about the mess. |/ ////////| +----------------------+-----------------------------------+-----------+