FT_UNSQZN()
Uncompress a numeric compressed by FT_SQZN()
──────────────────────────────────────────────────────────────────────────────

Syntax

FT_UNSQZN( <cCompressed>, <nSize> [, <nDecimals> ] ) -> nValue

Arguments

<cCompressed> - Compressed string, obtained from FT_SQZN()

<nSize> - Size of numeric field

<nDecimals> - Optional number of decimal places

Returns

nValue - Uncompressed numeric value

Description


The FT_UNSQZN function returns the numeric value from the compressed
string. The compression is 50% the storage space of the original
number. The original number must have been compressed using the
FT_SQZN() function.

This function, along with FT_SQZN() can be used to reduce disk storage
requirements for numeric fields in a database file.

Examples


mcust_id := FT_UNSQZN(TRANS->cust_id,8),;
mamount := FT_UNSQZN(TRANS->amount,12,2)


Source: SQZN.PRG

Author: Joseph D. Booth, Sr.