GetTableModifyFlag()

Summary

Tests whether a table can be modified by ModifyTable().

Syntax

flag = GetTableModifyFlag(string view_name)

Returns

The string "True" if the table can be modified by ModifyTable(), or a string that describes why the table cannot be modified.

Notes

• GetTableModifyFlag() tests the table according to three criteria:

  • It must not be read-only.

  • It must be a dBASE, fixed-format text, or fixed-format binary table.

  • It must not be part of any joined view.

• GetTableModifyFlag() returns "True" if all three conditions are met, even though a call to ModifyTable() might still fail for other reasons (e.g., the user does not have file access, some files are in use by other users, or there is not enough disk space).

Example

test = GetTableModifyFlag("Employees")
if Upper(test) = "TRUE" then ShowMessage("The table can be modified")
else ShowMessage("The table cannot be modified: " + test)

Error Codes

See Also