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 +'
Thanks,
Jim Bentley
American Celiac Society
--- "A. Razzak Memon" <[EMAIL PROTECTED]> wrote:
> At 08:28 PM 9/27/2007, James Bentley wrote:
>
> >Razzak,
> >Thanks for documenting the CVTYPE function. Any chance of
> >getting the following items from COMMAND.INI documented
> >¢(FORMAT2 ( [arg1] , [nchar1] , [nchar2] , [letter] ))
> >¢(HZC ( [string] ))
> >¢(ISTR ( [string] , [pos] ))
> >¢(MOGETC (0))
> >¢(MOGETR (0))
> >ISTR seems to give same results as ICHAR. Converts the
> >single character as "pos" into corresponding ASCII integer
> >value.
>
> Sure, James!
>
> FYI, the function (ISTR('String',position)) has already been
> documented as Tip of the Day #2 (09/27/2007).
>
> Please stay tuned ...
>
> Very Best R:egards,
>
> Razzak.
>
>
Jim Bentley
American Celiac Society
[EMAIL PROTECTED]
tel: 1-504-737-3293
____________________________________________________________________________________
Yahoo! oneSearch: Finally, mobile search
that gives answers, not web links.
http://mobile.yahoo.com/mobileweb/onesearch?refer=1ONXIC
