i run this command -
create table "students"("Name" char(20), "ad.no"numeric(4), "marks"numeric(3));
the command is successfully executed
now i run this command -
insert into "students"(Name, ad.no, marks)
values('Akshat','6183','99');
And i get this error -
Table already exists: students in statement [create table "students"]
Pls help
What did i do wrong ?
In fact I opened a new base and executed these commands and did ot create a single table earlier
Thanks in advance
(btw i am a beginner)
[Solved] Table already exists error in base
-
- Posts: 3
- Joined: Mon Mar 29, 2021 11:38 am
[Solved] Table already exists error in base
Last edited by AkshatTumkur on Mon Mar 29, 2021 12:52 pm, edited 2 times in total.
open office version 4.1.9
my OS - Win 10 pro
my OS - Win 10 pro
Re: Table already exists error in base
Try menu:View>"Refresh Tables"
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
-
- Posts: 3
- Joined: Mon Mar 29, 2021 11:38 am
Re: Table already exists error in base
I have done that !!
The table has been created and I am able to view it too but when I am trying to insert the values I am unable to
The table has been created and I am able to view it too but when I am trying to insert the values I am unable to
open office version 4.1.9
my OS - Win 10 pro
my OS - Win 10 pro
Re: Table already exists error in base
This is very weird. Can you enter the values manually?
I doubt that your syntax causes causes this error, but it should be:
with double-quotes around names and numbers without single quotes.
I doubt that your syntax causes causes this error, but it should be:
Code: Select all
insert into "students"("Name", "ad.no", "marks")
values('Akshat',6183,99);
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Table already exists error in base
Now I see what's wrong. You screenshot indicates that you are running both commands together. Once the table has been created, you have to remove the CREATE statement and run the INSERT statement alone.
By the way, your table has no primary key which is why you can't edit the table interactively in Base.
By the way, your table has no primary key which is why you can't edit the table interactively in Base.
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
-
- Posts: 3
- Joined: Mon Mar 29, 2021 11:38 am
Re: Table already exists error in base
Oh yeah thanks!
It works now
It works now
open office version 4.1.9
my OS - Win 10 pro
my OS - Win 10 pro