4D v16

START

Home

4D SQL Reference
- Transactions
- - Transactions
  - START
  - COMMIT
  - ROLLBACK

Home

4D v16

4D SQL Reference

Transactions

START



	Command STARTSTART [TRANSACTION]

Description

The START command is used to set the beginning of a transaction. If this command is passed when a transaction is already underway, it starts a subtransaction. The keyword TRANSACTION is optional.

Example

This example carries out a selection within a transaction:

START TRANSACTION;
SELECT * FROM suppliers
WHERE supplier_name LIKE '%bob%';
COMMIT TRANSACTION;