<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - BeforeUpdating and AfterUpdating events are not firing when records are edited in a Table Control"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=107839">107839</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>BeforeUpdating and AfterUpdating events are not firing when records are edited in a Table Control
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.2.5.1 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Base
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>BridgeportContractor@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=133306" name="attach_133306" title="Embedded example to demonstrate this issue">attachment 133306</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=133306&action=edit" title="Embedded example to demonstrate this issue">[details]</a></span>
Embedded example to demonstrate this issue
In a Table Control, in a Base Form, when a record is edited and then any record
motion occurs (i.e. the cursor is moved up or down a line which saves the
record to the database), I would expect that the BeforeUpdating event would
fire.
Instead BeforeUpdating fires only when the form is closed which isn't right
either.
This is an important event that can be used to ensure records are entered
correctly. (In my case I want to fill an entry with a computed value if it
happens to be null, before the record is saved.)
In the example database provide, the attached .odb will beep the speaker when
the event fires using this Basic code:
Private Sub BeforeUpdating(oEvent As Object)
Beep
End Sub
I can also confirm that the record actually does get changed in a similar form,
in which the form is connected to a MariaDB database. The record gets updated
but no event fires.
The AfterUpdating has a similar issue.</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>