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:
•Example: Update multiple tables