Results 1 to 3 of 3

Thread: Info on cconnection object of vbrichclient5

  1. #1

    Thread Starter
    Member
    Join Date
    Oct 2008
    Posts
    56

    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

  2. #2
    PowerPoster
    Join Date
    Aug 2010
    Location
    Canada
    Posts
    2,452

    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.

  3. #3

    Thread Starter
    Member
    Join Date
    Oct 2008
    Posts
    56

    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
  •  



Click Here to Expand Forum to Full Width