Loading...
 

DAL method: Update()

Updates one or more records in the database.
Syntax
Update()
Arguments
No arguments.
Return value
No return value.
Example
Update records where ID is '32' and First Name is 'Jim':
PHP
global $dal;
$tblUsers = $dal->Table("UsersTable");
$tblUsers->Param["ID"]=32;
$tblUsers->Value["First Name"]="Jim";
$tblUsers->Update();
ASP
dal.Table("UsersTable").Param("ID")=32
dal.Table("UsersTable").Value("First Name")="Jim"
dal.Table("UsersTable").Update()
The corresponding SQL query:
SQL
Update UsersTable set 'First Name'='Jim' where ID=32

See also

  • Example: Update multiple tables