At 08:59 PM 9/27/2007, James Bentley wrote:
Razzak,Was a little quick on the asking the question before reading the next email. The CVTYPE is a real handy function I can used in my application documentation application. It can replace this complex bit of code I have been using to format a columns data type. " SYS_DATA_TYPE, (IFEQ(SGET('00100000201111',1, + ABS(SYS_DATA_TYPE)),'0',SYS_TYPE_NAME, (IFEQ(ABS(SYS_DATA_TYPE),9,+ (SYS_TYPE_NAME&'('+ CTXT(SYS_PRECISION)+ CHAR(44)+ + CTXT(SYS_SCALE)+')'),(IFGT(SYS_LENGTH,0,(SYS_TYPE_NAME&'('+ + CTXT(SYS_LENGTH)+')'),'LONG'& SYS_TYPE_NAME)))))) FROM SYS_COLUMNS +'
Oh no ... However, very intuitive and slick code to get the data type. James, I hope now you can enjoy the CVTYPE function of R:BASE! Very Best R:egards, Razzak.
