<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Firebird: Autovalue inconsistency when inserting values into table via macro" href="https://bugs.documentfoundation.org/show_bug.cgi?id=124340#c4">Comment # 4</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Firebird: Autovalue inconsistency when inserting values into table via macro" href="https://bugs.documentfoundation.org/show_bug.cgi?id=124340">bug 124340</a> from <a class="email" href="mailto:drewjensen.inbox@gmail.com" title="Drew Jensen <drewjensen.inbox@gmail.com>"> Drew Jensen</a> <pre>(In reply to Gerhard Schaber from <a href="show_bug.cgi?id=124340#c3">comment #3</a>) > Created <a href="http://bugs.documentfoundation.org/attachment.cgi?id=150304" name="attach_150304" title="Test file">attachment 150304</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=150304&action=edit" title="Test file">[details]</a> > 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.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>