Vely logo Empower C
install  tutorials  examples
documentation  license  about

12.1.0 released on Sep 19, 2022

rollback-transaction


PURPOSE:


Rollbacks a SQL transaction.

SYNTAX:


rollback-transaction [ @<database> ]

DESCRIPTION:


rollback-transaction will roll back a transaction started with begin-transaction.

Database


Optional <database> is specified in "@" clause and is the name of the database_config_file.

EXAMPLES:


begin-transaction @mydb
run-query @mydb="insert into employee (name, dateOfHire) values ('Terry', now())"
run-query @mydb="insert into payroll (name, salary) values ('Terry', 100000)"
rollback-transaction @mydb

SEE ALSO:


Database ( begin-transaction   commit-transaction   current-row   database_config_file   database_queries   on-error   prepared_statements   query-result   rollback-transaction   run-query  )  SEE ALL (documentation)


Copyright (c) 2022 DaSoftver LLC. Vely is a trademark of Dasoftver LLC. The software and information herein are provided "AS IS" and without any warranties or guarantees of any kind. Icons copyright Paweł Kuna licensed under MIT. This web page is licensed under CC-BY-SA-4.0.