<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - Data Records Not Saved to External Firebird Database File"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=106463#c20">Comment # 20</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - Data Records Not Saved to External Firebird Database File"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=106463">bug 106463</a>
from <span class="vcard"><a class="email" href="mailto:drewjensen.inbox@gmail.com" title="Drew Jensen <drewjensen.inbox@gmail.com>"> <span class="fn">Drew Jensen</span></a>
</span></b>
<pre>(In reply to Lionel Elie Mamane from <a href="show_bug.cgi?id=106463#c18">comment #18</a>)
<span class="quote">> (In reply to Terrence Enger from <a href="show_bug.cgi?id=106463#c11">comment #11</a>)
>
> > (1) A user thinking of data entry into a database will expect changes
> > to become permanent at the end of each transaction, for some
> > meaning of transaction. If Base is linked to an external
> > database, this is how we work. Right?
>
> Yes, that's how it works when Base acts as a front-end to an external
> database. IMO, in a form or "table data entry view", each time one
> - switches from one record to another
> - closes the form
> - clicks the "save record" button in the "form navigation" toolbar
> that's a commit (end of a transaction).
>
> Most DBMSs have a mode where they "autocommit" at the end of each statement,
> and it is the default mode; it seems firebird does not, so IMO the SDBC
> driver should take care of issuing a commit at the end of each call to any
> of execute, executeQuery, executeUpdate in Statement.cxx and
> PreparedStatement.cxx</span >
Firebird most certainly does support Autocommit and by default. It must be
turned off if you don't want it and the Firebird File SDBC does just that and
turns it off during the connection process. I can't tell you the code line but
it is set to false after the connection is finished initialization.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>