Menu

#10 Transactions

Snapshot
open
nobody
3
2004-01-06
2002-08-20
No

Is it possible to switch off the transactions complletely,
or at least have a toggle on off..

Discussion

  • Tilo Muetze

    Tilo Muetze - 2002-09-18

    Logged In: YES
    user_id=152149

    Hi,
    what do you mean by "switching off transactions"?

    Regards,
    Tilo Muetze

     
  • Tilo Muetze

    Tilo Muetze - 2002-09-18
    • priority: 5 --> 3
    • status: open --> pending
     
  • Peter "mash" Morgan

    Logged In: YES
    user_id=405789

    if I do a select query it pops up with do you want to roll back or commit .. I want it on commit always ...

     
  • Peter "mash" Morgan

    • status: pending --> open
     
  • Tilo Muetze

    Tilo Muetze - 2002-09-18

    Logged In: YES
    user_id=152149

    Oh I see, ok this sounds useful. I will look into this.

     
  • Tilo Muetze

    Tilo Muetze - 2002-09-18
    • milestone: --> Snapshot
    • assigned_to: nobody --> tmuetze
     
  • Albert Chau

    Albert Chau - 2004-01-03

    Logged In: YES
    user_id=888889

    I'll be more than happy to implement this one, but can
    someone let me know whether transactions can be "switched
    off" within Firebird/Interbase? I only know that you can
    use "read committed" and "record versioning", but even then,
    when someone updates, it still creates a transaction...

    Please elaborate on the value of this request. For instance
    why would you want to "switch off the transactions"? That
    will help me figure out what I can do to help.

     
  • Tilo Muetze

    Tilo Muetze - 2004-01-04

    Logged In: YES
    user_id=152149

    I think Pete meant that he would like to see something that
    prevents Marathon from asking if the issued transaction
    should be committed or not. Now when you enter a select or
    insert statement and you execute it via F9 Marathon later
    asks you *always* if the transaction should be committed,
    even if you just issued a select statement. It's correct
    from the developer POV because every statement is
    encapsulated in a transaction, but from the users POV I
    agree with Pete.
    So I think we should only make it so that Marathon should
    not pop up a dialog "Do you want to commit?" when the
    statement issued was just a select.
    Comments?

     
  • Tilo Muetze

    Tilo Muetze - 2004-01-06
    • assigned_to: tmuetze --> nobody
     

Log in to post a comment.