[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