Skip to main content

Notifications

Update_Recordset

The update_recordset command allows the manipulation of many records in one
operation. This command speeds up database processing because of fewer calls
to the database. Review the update function using the update_recordset
command.



1
2
3
4
SalesTable salesTable;
update_recordset salesTable
setting salesName ="New Enterprises"
where salesTable.custAccount =="2001";

NOTE: You do not have to use the ttsbegin; or ttscommit; when you use the
update_recordset command, however it is recommended to consider using a
transaction when making other updates to the database at the same time.


Best Regards,
Hossein Karimi

Comments

*This post is locked for comments