Tersus: Database Update

Database UpdateDate: Jul 10, 2017 Database Update - Perform an SQL statement that updates database table(s) This action performs an SQL statement that updates a database table or several tables (to be used if Insert, Update and Delete are not sufficient). Triggers <SQL Statement> (non-repetitive text trigger [required]): The SQL statement to be performed (e.g. an UPDATE or DELETE statement).

In it simplest form, <SQL Statement> simply contains an SQL statement to be performed (e.g. DELETE FROM Backup_Log).

To enable more flexible statements, additional triggers can be used (e.g. the default triggers Value 1 and Value 2). For example, you may add a trigger Date and Time, and change <SQL Statement> to DELETE FROM Backup_Log WHERE Timestamp<=${Date and Time}. In this case, the action will delete all database records whose Timestamp field contains a value earlier than the value received through the Date and Time trigger at runtime.

If you don't need any additional trigger, delete the default triggers Value 1 and Value 2.

<Data Source>:Connecting to an External Database <Auto Commit> (non-repetitive Boolean trigger [not required]): Indication whether to interact with the database in auto-commit mode.

If <Auto Commit> exists and a Yes value is received, the database action is performed in auto-commit mode, regardless of any active transaction (see Database Transaction Support in Tersus).

Exit <Number of Records Affected> (non-repetitive numeric exit [not required]): The number of records in the database affected by the SQL statement. See Also:

To use the full functionality of this web site, JavaScript needs to be turned on.

For best results, use the Firefox browser..

Loading ...