Data Access Layer

Variable/Array

Description

Table("TableName")

Provides access to the TableName.

Example:

dal.Table("Cars")

Value("FieldName")

Provides access to the field values to be updated or added.

Example:

dal.Table("Cars").Value("Make")

Param("FieldName")

Provides access to the field values. This function is used in the WHERE clause of the update query. This allows you to avoid the confusion when the same field appears in the field list and in WHERE clause.

Example:

dal.Table("UsersTable").Param("FirstName")="Bob"
dal.Table("UsersTable").Value("FirstName")="Jim"
dal.Table("UsersTable").Update()

The corresponding SQL query:

Update UsersTable set 'FirstName'='Jim' where 'FirstName'='Bob'

Method

Description

Add()

Inserts a new record into the database.

CustomQuery()

Runs a custom SQL query.

Delete()

Deletes one or more records from the database.

DBLookup()

Executes an SQL query passed as a parameter and returns the first value of the first entry or null if nothing is found.

FetchByID()

Selects one or more records matching the condition.

Query()

Selects records from database and sorts the data by orderby field/fields and returns the recordset.

QueryAll()

Selects all records.

TableName()

Returns the table name. This function is used for complex queries with calculated fields or joined tables.

Update()

Updates one or more records in the database.

UsersTableName()

Returns a properly formatted login table name.

whereAdd()

Adds a new AND condition to the existing WHERE clause.