Ask Your Question
0

Prevented from doing a simple insert in query mode?

asked 2016-04-29 09:35:59 +0100

sab15 gravatar image

Hi,

I'm new to Base and trying to do a simple insert in my new database.

insert into table values (xxx,xxx,xxx,...)

I am getting an error message stating that I cannot do an insert and only queries are allowed. What am I missing here? I find it hard to believe that I can't do an insert.

Thanks in advance.

SAB

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
0

answered 2016-04-29 11:46:26 +0100

peterwt gravatar image

You can only run a SELECT Query as a Query. All other SQL operations need to be run as @pierre-yves samyn stated.
If you need to run such a Query regularly you can run it using a Macro.

edit flag offensive delete link more

Comments

Thanks. I just did it now that way and am getting an error - 1: Table not found in statement [insert into employee]

I'm executing: insert into employee (ID, Name, Post, Salary) values (1, 'Joe Jon', 'Accountant', 50000);

I did create a table named employee with the columns listed. Any idea what the problem could be?

sab15 gravatar imagesab15 ( 2016-04-29 15:16:14 +0100 )edit

Table names and field names need to be quoted.

INSERT INTO "employee" ("ID", "Name" etc.

peterwt gravatar imagepeterwt ( 2016-04-30 00:13:04 +0100 )edit

Thanks peter!

sab15 gravatar imagesab15 ( 2016-05-03 09:32:07 +0100 )edit
0

answered 2016-04-29 10:10:23 +0100

pierre-yves samyn gravatar image

Hi

INSERT queries can only be executed by ToolsSQL▸paste (type) the SQL▸click Execute

Regards

edit flag offensive delete link more

Comments

Thank you!

sab15 gravatar imagesab15 ( 2016-04-29 10:12:54 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-04-29 09:35:59 +0100

Seen: 346 times

Last updated: Apr 29 '16