<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 - Simple table created using Firebird Embedded produces an error during data entry"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=108060">108060</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Simple table created using Firebird Embedded produces an error during data entry
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.3.3.2 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=133521" name="attach_133521" title="screen shot with error message">attachment 133521</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=133521&action=edit" title="screen shot with error message">[details]</a></span>
screen shot with error message
When using the Firebird Embedded database when I create a simple table I can't
insert data into it without getting, "Error inserting the new record", and
firebird_sdbc_error: *validation error for column "Table1"."ID", value "***
null ***" caused by 'isc_dsql_execute'
How to recreate this:
Step 1 create a simple table:
Open LibreOffice and select:
File
New
Database
* Create a new database
Select: Firebird Embedded
Next>>
Select either:
* Yes, register the database, OR
* No, do not register the database
Click Finish
Click Save
Then select: Create a Table in Design View...
On line 1 enter: Field Name = "ID" | Field Type = "Integer"
On line 2 enter: Fidld Name = "Test" | Field Type = "Text"
Right click on green arrow left of ID and select Primary Key
Below set AutoValue to Yes
Close the window
Do you want to save the changes? Save to table name "Table1".
Click Yes
Step 2 test the table:
Double click on "Table1" to open it.
Type something in text and hit return.
Expected ID becomes "0" and cursor moves to next line.
Result is the attached error message.</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>