[Solved] Table not found in statement

Creating tables and queries

[Solved] Table not found in statement

Postby Skrag » Mon Jul 24, 2017 7:34 pm

Dear all,

This seems like an easy problem, so I hope it hasn't been answered yet. At least I didn't find an answer.

I want to update my table und fill a newly created column with the default value. I use the following SQL code:

UPDATE TABLE "tblExample" SET "Embedded" = 0

It gives me this error message: "1: Table not found in statement [update table]"

Both table and column exist. I tried giving it "0" instead of 0 as a value, it doesn't help. I also tried reopening the database. The database is embedded, HSQL engine. The column is a foreign key, but I made sure that the desired value respects the integrity. Entering the value manually works. The command type ALTER TABLE works.

What am I doing wrong?
Last edited by Skrag on Tue Jul 25, 2017 1:53 pm, edited 1 time in total.
using OpenOffice 4.1.3 on macOS Sierra (10.12.3)
Skrag
 
Posts: 13
Joined: Wed Mar 01, 2017 3:17 pm
Location: Konstanz, Germany

Re: Table not found in statement

Postby UnklDonald418 » Mon Jul 24, 2017 8:01 pm

The keyword TABLE in your statement isn't needed. Try
Code: Select all   Expand viewCollapse view
UPDATE "tblExample" SET "Embedded" = 0;
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.5 & LibreOffice 6.0.4.2 - Windows 10 Professional
UnklDonald418
Volunteer
 
Posts: 804
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: Table not found in statement

Postby Skrag » Tue Jul 25, 2017 1:53 pm

Alright, now I feel stupid. I shouldn't ask stuff like this after a long day. I probably thought about the "ALTER"-commands and tried to do it in a parallel way. Thanks though!
using OpenOffice 4.1.3 on macOS Sierra (10.12.3)
Skrag
 
Posts: 13
Joined: Wed Mar 01, 2017 3:17 pm
Location: Konstanz, Germany


Return to Tables & Queries

Who is online

Users browsing this forum: No registered users and 5 guests