Retro video games delivered to your door every month!
Click above to get retro games delivered to your door ever month!
X-Hacker.org- RaSQL/B 6.1a for Clipper - <b>n_xlen()</b> http://www.X-Hacker.org [<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
N_XLEN()
Get display length of specified field

Syntax
N_XLEN(<cField> | <nField>)

RDD Option
LEN()

Argument
<Field> is a field, specified by name or by field  number. If you use a 
field name, case is ignored. 

Returns
Display length of specified field.

Remarks
The display length is the number of bytes that a field takes up on the 
screen, as opposed to the stored length that is the number of bytes the 
field takes up in the record. For data types C, N, L and these are the same. 
However, a 4byte packed decimal field, for example, requires 9 bytes when 
displayed; an 8byte floating point field can display numbers of up to 19 
digits. 

If the table contains a variable length field (type M or ML) then the record 
size reflects the maximum field length as defined when the table was 
created.

See Appendix A for a list of display lengths for each data type.

Use N_XSLEN() to obtain the internal, stored length of a field.

This function may be useful when using the RDD because the Clipper LEN() 
function works only with Character fields.

Example
? N_XLEN('float_number')
17
? N_XSLEN('float_number')
8


See Also: Appendix A N_XSLEN()

Online resources provided by: http://www.X-Hacker.org --- NG 2 HTML conversion by Dave Pearson