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.
Jim Bentley
American Celiac Society
--- "A. Razzak Memon" <[EMAIL PROTECTED]> wrote:
>
> Wednesday, September 27, 2007
>
> Tip of the Day: Finding Data Type for a given Column or
> Variable
>
> Did you know that you can find the data type for a given
> column
> name or variable by using the undocumented CVTYPE function?
>
> Here's how:
>
> Syntax:
>
> (CVTYPE('colvarname',flag))
>
> Returns the data type for a given column or variable name.
>
> To return the data type for a given column, a zero "0" flag
> must be used. To return the data type for a given variable,
> the one "1" flag must be used.
>
> Start R:BASE for DOS or Windows
>
> After CONNecting to ConComp or RRBYW14, try the following
> two examples at the R> prompt:
>
> Example 01.
>
> SET VAR vCustIDType TEXT = (CVTYPE('CustID',0))
> SET VAR vEmpCity TEXT = (CVTYPE('EmpCity',0))
>
> SHOW VARIABLES
>
> vCustIDType = INTEGER TEXT
> vEmpCity = TEXT,16 TEXT
>
> Example 02.
>
> SET VAR vCustIDType TEXT = (CVTYPE('CustID',0))
> SET VAR vVarInquiry TEXT = (CVTYPE('vCustIDType',1))
>
> SHOW VARIABLES
>
> vCustIDType = INTEGER TEXT
> vVarInquiry = TEXT,7 TEXT
>
> NOTES:
>
> . When using the zero flag to return column data types,
> you must be CONNected to a database.
>
> . When returning a TEXT data type, the length is
> included and is separated with a comma. When returning
> a NUMERIC data type, the precision and scale are
> separated with commas.
>
> Very Best R:egards,
>
> Razzak.
>
>
Jim Bentley
American Celiac Society
[EMAIL PROTECTED]
tel: 1-504-737-3293
____________________________________________________________________________________
Don't let your dream ride pass you by. Make it a reality with Yahoo! Autos.
http://autos.yahoo.com/index.html
