SET MBLOCKSIZE

Change the block size for memo files

Syntax

      SET MBLOCKSIZE TO <nSize>

Arguments

<nSize> is the memo file block size in bytes. The initial memo file block size depends on the RDD. For most drivers that support the .dbt memo file format, it is 512 bytes. However, if you are using BLOB files (.dbv memo file format) via inheritance from the DBFMEMO driver, the default is 1.

Description

SET MBLOCKSIZE is functionally equivalent to calling DBINFO( DBI_MBLOCKSIZESIZE, <nSize>). Refer to this function for more information. SET MBLOCKSIZE sets the block size for the memo file associated with the database.

The block size is the minimum amount of space in bytes allocated in memo files when storing character strings in memo fields.

The initial memo block size depends on the replaceable database driver used to open a database in a work area.

The following table lists the default sizes for memo blocks of RDDs shipped with Harbour:

Default memo block sizes

         Memo type Block size Changeable
         --------- ---------- ----------
             DBT      512     No
             FPT       64     Yes
             SMT       64     Yes

Examples

      .  The following example illustrates the SET MBLOCKSIZE command:
      USE Inventor NEW
      SET MBLOCKSIZE TO 256
      ? DBINFO(DBI_MBLOCKSIZESIZE)         // Result: 256

Seealso

DBINFO(), RddSetDefault(), Set()