SET TABLEVALIDATE Command

Specifies the level of table validation to perform.

You can use SET TABLEVALIDATE when you want a lower level of table integrity checking than the default setting.

SET TABLEVALIDATE TO [nLevel]

Parameters

• nLevel
  Specifies the table validation level. If omitted, the default value of nLevel is 3.

  The following table lists the values for nLevel.

  nLevel	Description
  0	Does not perform table validation.
  1	Validate record count when opening a table. Note   The table (.dbf) file header is locked during validation. This can result in decreased scalability when tables are opened as shared, for example, by calling USE tableName SHARED, or when calling a SQL SELECT, INSERT, UPDATE, or DELETE command for an unopened table, and SET EXCLUSIVE is OFF.
  2	Validate record count when appending or inserting records and writing them to disk.
  3	Validate as described by nLevel=1 and nLevel=2. (Default)

Remarks

SET TABLEVALIDATE does not have repair functionality; it performs only integrity checks as specified by nLevel.

SET TABLEVALIDATE does not affect temporary files or cursors; that is, table validation is not performed.

You can use SET TABLEVALIDATE in Config.fpw as follows:

TABLEVALIDATE = nLevel

See Also

SET Command Overview | USE Command | SELECT - SQL Command | INSERT - SQL Command | UPDATE - SQL Command | DELETE - SQL Command | Programming for Shared Access