The functions that deal with delimeters are RAISE and LOWER. The UniVerse defined delimiters are from 255 to 248. I use LOWER to combine all associated records into fields of one record for archiving and RAISE to unarchive into individual records.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Martin Scholl Sent: Wednesday, September 01, 2004 7:04 PM To: [EMAIL PROTECTED] Subject: RE: [U2] UV: FMT and FMTS processing of CHAR(247) differs I've heard once that UniVerse goes down to char(246) as system delimiters. Don't know where it came from. (Probably this list) I would love to have the ability to access those values with the normal tools of Basic or UniObjects, but I guess this is one case where there show through. Martin Scholl President Martin Scholl Consulting, Inc. http://www.hipaasuite.com/ mailto:[EMAIL PROTECTED] 18910 New Hampshire Ave Brinklow, MD 20862 301-924-5537 Phone 301-570-0139 Fax 301-613-9572 Cell -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Barry Brevik Sent: Wednesday, September 01, 2004 3:36 PM To: '[EMAIL PROTECTED]' Subject: RE: [U2] UV: FMT and FMTS processing of CHAR(247) differs >Problem: FMTS is supposed to FMT each field of a given dynamic array. >It appears to be wrong if source data in a field of the array contains CHAR(247). If you look at the DOCs for REMOVE (for example), it indicates that the lowest system delimiter is CHAR(248), and that is true with REMOVE. However, I've noticed that some of the functions like FMTS() and FIELDS() also consider CHAR(247) to be a system delimiter. Experimentation has shown me that CHAR(246) and below are safe to use. I've always wondered about the discrepancy though. Barry ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
