sizeof(
sizeof(
NAME
)

The sizeof( function calculates the amount of memory used by a field or a variable.

Parameters

This function has one parameter:

name – is the name of the field or variable that you want to calculate the size of.

Description

The function returns the number of bytes of memory used by the variable or field (not the entire field, but just the cell in the current record).

The sizeof( function can be used to decide if a numeric or date field is empty or not. The example below selects all the records with no price (not the same as records with a price of zero).

    select sizeof(Price)=0

You can also quote the field or variable name (earlier versions of Panorama required this, but quoting is no longer a requirement).

    select sizeof("Price")=0

See Also

- zeroblank( -- tells Panorama to treat zeroes as empty space.

History

Version | Status | Notes
10.0 | Updated | Carried over from Panorama 6.0, but no longer requires that the name parameter be quoted.