Screenshot: SQL Query fails to duplicate record

[ophis]

Following Google AI instructions re: how to duplicate a record in a LibreOffice Base table, I opened an .odb file with a single table called AllRecords, selected Queries/Create query in SQL view… and pasted the text below, seeking to duplicate a record with primary key of 188:

INSERT INTO “AllRecords” (“Order”, “Family”, “Species”, “CommonName” , “Synonyms” , “Date” , ”Location”, “State”, “County”, “WetlandIndicator” , “Notes” , “Specimen”)
SELECT “Order”, “Family”, “Species”, “CommonName” , “Synonyms” , “Date” , ”Location”, “State”, “County”, “WetlandIndicator” , “Notes” , “Specimen”
FROM “AllRecords”
WHERE “ID” = 188;

I have attached the resulting error message, which I don’t understand. It seems to me that I used the recommended syntax

[ophis]

forgot to add screenshot

[ophis]

something else I don’t understand is why some of the text in query window is brown and some is green

[ophis]

btw here are the on-line instructions

[bantoniof]

@ophis

some of the text in query window is brown and some is green

I think it is for the quotes, in some places they are straight quotes and in other curved quotes.
If I’m not mistaken, SQL supports only straight quotes

[RobertG]

Right, quoting will allow " or a bactick (special for MariaDB). If you write code here in this forum you have to set is as preformatted text. Code, copied from “normal” text content, will show the wrong quoting.

By the way: The query GUI doesn’t allow to execute updates or inserts. There are feature requests for allowing this, but who would implement it?

[Wanderer]

@ophis

It seems to me that I used the recommended syntax

With exception of the quotes.
.
But the error message tells you used the wrong place. Your INSERT INTO is no query (where you ask for a result-set), but a command (where you say “do this” and all you will get as a result is a number of altered rows.
.
Use Menu Tools → SQL and try your command there., but you have to change all curly quotes to straight ones. (This you can see in the screenshot: All quotes around green words are wrong.)
.
PS: Have you seen the much easier suggestion by RobertG:

Screenshot: basic runtime error in macro for duplicating records

You have written such an insert I have described. This code should set instead of ""name"",""forename"" … inside the macro - starting with SUB. But you could do all this much easier directly: Set “Datasource as table” (Button in navigationbar of the form). Left mouse button on the row-header of the row you want to copy. Press mouse button and move mouse down. (+) will show you try to copy. Then insert this content and all will be copied.

[ophis]

my thanks to everyone trying to help me with this. Much appreciated

[ophis]

at last the SQL method worked, once I replaced all curly quotes with hashtags, plus chose the Tools/SQL menu item and pasted the code in the dialog box
attached is resulting message, and yes, on re-opening the table I see a single new record has been added, a duplicate of No. 188, which was my goal
I won’t adopt this approach without more testing but I certainly would not have got this far w/out the help I’ve received in this forum