savepoint()

Read(298) Label: set, savepoint,

Here’s how to use savepoint() function.

db.savepoint()

Description:

Set the savepoint to which you can later rollback.

Syntax:

db.savepoint(spn)

Note:

The function creates a savepoint named spn. The name must not be omitted and repeated

Parameters:

db

Database connection

spn

Savepoint name

Return value:

  Boolean

Example:

 

A

 

1

=connect("demo")

 

2

=A1.savepoint("num1")

Set a savepoint named "num1"