Prevented from doing a simple insert in query mode?

[sab15]

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

[PYS]

Hi

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

Regards

[sab15]

Thank you!

[peterwt]

You can only run a SELECT Query as a Query. All other SQL operations need to be run as @PYS stated.

If you need to run such a Query regularly you can run it using a Macro.

[sab15]

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?

[peterwt]

Table names and field names need to be quoted.

INSERT INTO “employee” (“ID”, “Name” etc.

[sab15]

Thanks peter!