SET BLOB SIZE

4D - Documentation   Français   English   German   Spanish   4D v11 SQL, Command Theme List   4D v11 SQL, Command Alphabetical List   4D v11 SQL, Constant Theme List   Back   Previous   Next

version 6.0


SET BLOB SIZE (blob; size{; filler})

ParameterTypeDescription
blobBLOBBLOB field or variable
sizeNumberNew size of the BLOB
fillerNumberASCII code of filler character

Description

SET BLOB SIZE resizes the BLOB blob according to the value passed in size.

If you want to allocate new bytes to a BLOB and want to have those bytes initialized to a specific value, pass the value (0..255) into the filler optional parameter.

Examples

1. When you are through with a large process or interprocess BLOB, it is good idea to free the memory it occupies. To do so, write:

   SET BLOB SIZE(aProcessBLOB;0)
   SET BLOB SIZE(<>anInterprocessBLOB;0)

2. The following example creates a BLOB of 16K filled of 0xFF:

   C_BLOB(vxData)
   SET BLOB SIZE(vxData;16*1024;0xFF)

See Also

BLOB size.

Error Handling

If you cannot resize a BLOB due to insufficient memory, the error -108 is generated. You can trap this error using an ON ERR CALL interruption method.


4D - Documentation   Français   English   German   Spanish   4D v11 SQL, Command Theme List   4D v11 SQL, Command Alphabetical List   4D v11 SQL, Constant Theme List   Back   Previous   Next