Databases

inline actions, records, fields, result sets, datasource helpers, SQL data sources, ODBC, and FileMaker.

Subcategories

Data Sources 13Database Actions 27Database Results 19FileMaker 3

Reference Pages

checked

Returns checked-state text for form controls.

selected

Returns selected-state text for form controls.

value_list

Iterates or returns datasource value-list values.

-findAll

Finds all records in an inline action.

-search

Searches records in an inline action.

inline

Executes a database action or SQL statement.

inline database actions

inline performs database searches, SQL statements, adds, updates, deletes, and result block execution.

keyColumn_name

keyColumn_name is a callable in the Database Actions group.

keyColumn_value

keyColumn_value is a callable in the Database Actions group.

keyField_name

keyField_name is a callable in the Database Actions group.

keyField_value

keyField_value is a callable in the Database Actions group.

sort_arguments

sort_arguments is a callable in the Database Actions group.

sort_fieldItem

sort_fieldItem is a callable in the Database Actions group.

sort_orderItem

sort_orderItem is a callable in the Database Actions group.

column

Returns a column value from the current row.

column_name

column_name is a callable in the Database Results group.

column_names

column_names is a callable in the Database Results group.

field

Returns a field value from the current record.

records

Iterates records in an inline result.

rows

Iterates rows in an inline result.

rows_array

rows_array is a callable in the Database Results group.

portal

Iterates a FileMaker portal.

repeating

Iterates FileMaker repeating-field values.