A Database Resource acts as an interface to a database. A Database Resource can be used to execute SQL select, insert, update and delete statements.
You can create a new Database Resource by selecting File > New > Database Resource. This will open the Database Resource editor where the database connection, the SQL statements and Resource Fields can be configured.
Resource Fields that match the name of a column will be automatically populated with the values from that column. Column and field names are case-sensitive.
There are two options for accessing data:
- table operations handle SQL statements that deal with multiple rows at a time, with the Resource Fields mapped to a Form's Tables.
- non-table operations handle SQL statments that deal with one row at a time, with the Resource Fields mapped to a Form's Fields.
Prepared Statements are faster and allow a wider range of data types so we recommend that you check the Use Prepared Statements property whenever possible.