[Libreoffice-bugs] [Bug 124340] Firebird: Autovalue inconsistency when inserting values into table via macro
bugzilla-daemon at bugs.documentfoundation.org
bugzilla-daemon at bugs.documentfoundation.org
Sat Apr 20 16:24:29 UTC 2019
https://bugs.documentfoundation.org/show_bug.cgi?id=124340
Drew Jensen <drewjensen.inbox at gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |NEW
Ever confirmed|0 |1
Resolution|WORKSFORME |---
--- Comment #6 from Drew Jensen <drewjensen.inbox at gmail.com> ---
Well, it appears I was wrong.
Firebird and hsql is not identical here.
The views (table or form) under hsql sdbc will recognize that an insert
happened since the last refresh on a resultset and retrieve a valid (new I am
guess) autoinc value.
Views under firebird sdbc generate an error message that there is a PK
violation, and in the error message displays a value that would in fact be a
collision in the table; HOWEVER if you examine the underlying Table there is an
insert of the supplied data from the form and the, database wise, correct next
autoinc value.
In both cases if I refresh open result sets after the insert in the macro
however there is no problem with finding the next autoinc value, but with hsql
that is not required.
I can make a quick video I think to show this.. so it is not works for me.
--
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190420/5c9ae239/attachment.html>
More information about the Libreoffice-bugs
mailing list