SET MBLOCKSIZE

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()

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s