Please enable JavaScript to view this site.

Navigation: » No topics above this level «

DAL method: Update() (Deprecated)

Scroll Prev Next More

 

Deprecated

This function is deprecated, and we recommend using the DB:Exec() function from Database API.

 

Updates one or more records in the database.

Syntax

Update()

Arguments

No arguments.

Return value

No return value.

Example

Update the record where ID is 32, making the FirstName field value 'Jim' and LastName field value 'Morrison':

 

dal.Table("UsersTable").Param("ID")=32
dal.Table("UsersTable").Value("FirstName")="Jim"
dal.Table("UsersTable").Value("LastName")="Morrison"
dal.Table("UsersTable").Update()

 

The corresponding SQL query:

 

Update UsersTable set FirstName='Jim', LastName='Morrison' where ID=32

See also:

DB API: Exec

Database API

Example: Update multiple tables

About Data Access Layer