-
Jul 3rd, 2019, 10:57 AM
#1
Thread Starter
Member
Info on cconnection object of vbrichclient5
Hello everyone.
Some features and properties are available in the object "cConnection" that I can imagine the meaning of but I would like to be sure.
They are:
EnableNestedTransactions
BusyTimeOutSeconds
TransactionStack
TransactionStackCounter
Moreover, I discovered that:
the functions CommitTrans,BeginTrans,RollbackTrans they can have one or more arguments.
Someone has some examples of the use of the way to manage the concurrent use of the same db from different applications.
Thanks
-
Jul 3rd, 2019, 12:19 PM
#2
Re: Info on cconnection object of vbrichclient5
EnableNestedTransactions
Transactions in SQLite can be "nested" and named - you can have transactions within transactions within transactions each with its own name active as a "save point"... This can allow you to "restore" to certain save points if an error occurs when you try to commit a nested transaction. The point to which you restore depends entirely on how you are managing your data. Nested transactions are disabled by default. You can learn more about SQLite transactions here: https://www.sqlite.org/lang_transaction.html and savepoints here: https://www.sqlite.org/lang_savepoint.html
TransactionsStack
This is a collection of nested & named transactions.
TransactionStackCounter
This will return the # of transactions in the transaction stack.
BusyTimeOutSeconds
This is the number of seconds that RC5 will attempt to try/retry a database operation before timing out if the database is too busy.
Re: BeginTrans, RollbackTrans, and CommitTrans - the optional transaction/savepoint name parameter is used when nested transactions are enabled, but otherwise it should not be used.
Last edited by jpbro; Jul 3rd, 2019 at 12:36 PM.
-
Jul 4th, 2019, 04:58 AM
#3
Thread Starter
Member
Re: Info on cconnection object of vbrichclient5
Thanks jpbro.
I have read:https://www.sqlite.org/lang_transaction.html and more
I have some questions:
1) Then Begin,Rollback and Commit are used for run a immediate transaction. It is correct?
2) What relationship does the pragma "Synchronous" have with transactions?
Thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|