PC SOFT

ONLINE HELP
 WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English EN
New WINDEV, WEBDEV and WINDEV Mobile 27 feature!
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Declares a transaction savepoint. This allows you to roll the transaction back to this savepoint later (<HFSQL connection>.TransactionRollbackToSavepoint).
Example
MyConnection is Connection
 
// Start transactions
MyConnection.TransactionStart()
 
// Actions A
 
// Declare a savepoint
MyConnection.TransactionSavepoint("MySavepoint")
 
// Actions B
 
// Undo all actions after the declaration of MySavepoint
MyConnection.TransactionRollbackToSavepoint("MySavepoint")
 
// Actions C
 
// Declare a savepoint
MyConnection.TransactionSavepoint("MySavepoint2")
 
// Actions D
 
// Validate (commit) transactions
// Actions A, C and D are taken into account,
// but not B, because they are between TransactionSavepoint()
// and TransactionRollbackToSavepoint
 
MyConnection.TransactionEnd()
 
// MySavepoint2 is disabled
Syntax
<Result> = <Connection>.TransactionSavepoint(<Savepoint name>)
<Result>: Boolean
  • True if the savepoint has been created,
  • False if a problem occurred. HErrorInfo returns more details about the error.
<Connection>: Connection variable
Name of the Connection variable that describes the connection to an HFSQL server.
<Savepoint name>: Character string
Savepoint name.
Remark: The name of the savepoint cannot start with "#".
Remarks
  • This function must be used in a transaction.
  • The corresponding SQL statement can also be used: "SAVEPOINT identifier".
  • This function is not available:
    • on HFSQL files in cluster mode,
    • with files handled via a Native Connector.
Business / UI classification: Business Logic
Component: wd270hf.dll
See also
Minimum version required
  • Version 27
This page is also available for…
Comments
Click [Add] to post a comment