START

This is the legacy 4D documentation web site. Documentations are progressively being moved to developer.4d.com

Home

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

Home

4D v20 R7

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;