Table not found in statement

Creating tables and queries
Post Reply
VINEET JETHANI
Posts: 1
Joined: Thu Feb 04, 2021 7:25 am

Table not found in statement

Post by VINEET JETHANI »

i am getting this error continously while typing the below statement
SELECT Emp_Name,Designation,Salary,Salary+5000 FROM Employee;

table not found in statement(update employee)
OPEN OFFICE VERSION 4.1.7 AND OPERATING SYSTEM WINDOWS 10
UnklDonald418
Volunteer
Posts: 1546
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: Table not found in statement

Post by UnklDonald418 »

Is the table named Employee or employee?
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.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Table not found in statement

Post by Villeroy »

Code: Select all

SELECT "Emp_Name","Designation","Salary","Salary"+5000 FROM "Employee";
with all names quoted, case sensitive names.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Post Reply