Ask Your Question

Base insert into syntax [closed]

asked 2015-03-11 13:51:34 +0100

PaulRaes gravatar image

I get the error "de selectie ontbreekt" (selection is missing) on the following INSERT INTO : INSERT INTO "Countries"("Ctry_Code", "Ctry_TelPrefix", "Ctry_Name_EN") SELECT "Ctry_Code", "Ctry_TelPrefix", "Ctry_Name_EN" FROM "CtryCodes_Tbl".

I cannot find what I'm doing wrong.

Can any one tell me what I'm doing wrong here ?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-17 12:33:33.357462

1 Answer

Sort by » oldest newest most voted

answered 2015-03-11 14:12:24 +0100

PaulRaes gravatar image

I think, I found what's going wrong. Base queries can apparently only be "Select" commands.

When I execute the above SQL command in the "Execute SQL Command" dialogue window that opens on the Extra/SQL Menu option, the command executes without any problem.

I hope this will save other people the hours of lost time that I spend on this.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2015-03-11 13:51:34 +0100

Seen: 954 times

Last updated: Mar 11 '15