FileMaker system columns

FileMaker software adds system columns (fields) to all of the rows (records) in all of the tables that are defined in the FileMaker Pro file. For ODBC applications, these columns are included in the information returned by the catalog function SQLSpecialColumns. For JDBC applications, these columns are included in the information returned by the DatabaseMetaData method getVersionColumns. The columns can also be used in ExecuteSQL functions.

ROWID column

The ROWID system column contains the unique ID number of the record. This is the same value that the FileMaker Pro Get(RecordID) function returns.

ROWMODID column

The ROWMODID system column contains the total number of times changes to the current record have been committed. This is the same value that the FileMaker Pro Get(RecordModificationCount) function returns.

SELECT ROWID, ROWMODID FROM MyTable WHERE ROWMODID > 3