Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

SET BLOCKSIZE Command

Visual Studio .NET 2003

Specifies how Visual FoxPro allocates disk space for the storage of memo fields.

SET BLOCKSIZE TO nBytes

Parameters

nBytes
Specifies the block size in which disk space for memo fields is allocated. If nBytes is 0, disk space is allocated in single bytes (blocks of 1 byte). If nBytes is an integer between 1 and 32, disk space is allocated in blocks of nBytes bytes multiplied by 512. If nBytes is greater than 32, disk space is allocated in blocks of nBytes bytes.

If you specify a block size value greater than 32, you can save substantial disk space.

Remarks

The default value for SET BLOCKSIZE is 64. To reset the block size to a different value after the file has been created, set it to a new value and then use COPY to create a new table. The new table has the specified block size.

SET BLOCKSIZE is scoped to the current data session.

See Also

COPY FILE | MODIFY STRUCTURE | PACK | SET DATASESSION

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.