SQL Reference
Table Of Contents
- Chapter 1 Introduction
- Chapter 2 Supported standards
- Support for Unicode characters
- SQL statements
- SELECT statement
- SQL clauses
- FROM clause
- WHERE clause
- GROUP BY clause
- HAVING clause
- UNION operator
- ORDER BY clause
- OFFSET and FETCH FIRST clauses
- FOR UPDATE clause
- DELETE statement
- INSERT statement
- UPDATE statement
- CREATE TABLE statement
- TRUNCATE TABLE statement
- ALTER TABLE statement
- CREATE INDEX statement
- DROP INDEX statement
- SQL expressions
- SQL functions
- FileMaker system objects
- Reserved SQL keywords
- Index
Chapter 2 | Supported standards 36
FileMaker system columns
FileMaker adds system columns (fields) to all of the rows (records) in all of the tables that are
defined in the FileMaker 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 ROWM
ODID 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(Reco
rdModificationCount) function returns.
Example
SELECT ROWID, ROWMODID FROM MyTable WHERE ROWMODID > 3