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_xslen()</b> http://www.X-Hacker.org [<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
N_XSLEN()
Get internal, stored length of specified field

Syntax
N_XSLEN(<cField> | <nField>)

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

Returns
Internal, stored length of specified field

Remarks
The stored length is the number of bytes the field takes up in the record, 
as opposed to the display length, which is the number of bytes that a field 
takes up on the screen. 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 displays numbers 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 opened.

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

Examples
? N_XLEN('float_number')
18

? N_XSLEN('float_number')
8


See Also: Appendix A N_XLEN() N_XUSE()

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