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 35
1 FieldType - The SQL data type of the field.
1 FieldId - The unique ID for the field.
1 FieldClass - One of three values: Summary, for summary fields; Calculated, for calculated
results; or Normal.
1 FieldReps - The number of repetitions of the field.
1 ModCount - The total number of times changes to this table’s definition have been committed.
Example:
SELECT * FROM FileMaker_Fields WHERE TableName=’Sales’
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 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.
Example:
SELECT ROWID, ROWMODID FROM MyTable WHERE ROWMODID > 3