https://bugs.documentfoundation.org/show_bug.cgi?id=108060
Bug ID: 108060
Summary: Simple table created using Firebird Embedded produces
an error during data entry
Product: LibreOffice
Version: 5.3.3.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: bridgeportcontrac...@gmail.com
Created attachment 133521
--> https://bugs.documentfoundation.org/attachment.cgi?id=133521&action=edit
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.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs