In my data base I have a table tblCompanyName with some data in it. If I do a "Select * from tblCompanyName everything works fine. However if do SQL “Insert into tblCompanyName ( fieldName) values (‘Something’)” I get a"Table not found error message. SQL command entered from Tools → SQL
Hello,
Have just tried using LO v6.4.0.3 with HSQLDB embedded. This worked without a problem (ID is auto increment):
INSERT INTO "KeyTest" ("Name1", "Name2") Values ('q', 'qq')
If you have further problems please edit your question to add your complete SQL statement as well as LO version and database used and along with OS should always be included in each question asked.
Note: Mixed case table or field names need to be surrounded with quotes.
Thanks that worked
As with all questions, please help others to know the question has been answered by clicking on the in upper left area of answer which satisfied the question.