[Libreoffice-bugs] [Bug 124340] Firebird: Autovalue inconsistency when inserting values into table via macro

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=124340

--- Comment #4 from Drew Jensen <drewjensen.inbox at gmail.com> ---
(In reply to Gerhard Schaber from comment #3)
> Created attachment 150304 [details]
> Test file
> 
> Run SQL command "INSERT INTO "table1" VALUES ( 1, 'firstname', 'lastname' )"
> Then try to add a record with the form (there is only one).

two things here:

First the insert command, if you change that to:
INSERT INTO "table1" ("FirstName", "LastName") VALUES ( 'Walter', 'Cronkite' )

It works fine. ALMOST

So, running that in the SQL window works without a glitch.

However, if you a Query Definition window, SQL Direct set to true, and run that
it successfully updated that table, with autoinc value for ID, but then returns
an error that 'The cursor is not open'. But the values are already updated in
the table.

I'll do this in a macro also, just to be sure but I won't be surprised if I get
that, what appears to be erroneous, error message again.

-- 
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/38a27f3f/attachment-0001.html>