insert query in Open office Base

Please read this http://www.linuxjournal.com/content/creating-queries-openofficeorg-base it might helps.

Hope this helps

Hi,
   I had tried to modify an already existing select query which is -
SELECT "DATAA"."name " AS "name ", "DATAA"."password" AS "password" FROM "DATAA" "DATAA" .Its running successfully. Now I want to modify select query to delete query which is
DELETE FROM "DATAA" WHERE "NAME"="GAUTAM". But its giving error that
" -The given command is not a SELECT statement.Only queries are allowed.
DELTE FROM "DATAA" WHERE "NAME"="GAUTAM" -".
And another thing is that I am using Windows XP.
Pl suggest me.
Thanks and regards,
Gautam

Hi Gautam

The general format for a simple SQL insert query is

INSERT INTO "table" ("col1_name","col2_name",...) VALUES (value_for_col1,value_for_col2,...)

The values must be given in a valid way for HSQLDB. For a VARCHAR that would be a string in quotes. I'm not sure about other data types. You might have to experiment. HSQLDB likes all its table and column names in quote - I think you know that already.

Instead of a VALUES statement, you can have a SELECT statement, in which case, everything selected is inserted in to the table.

Tony

Hi Tony,
    I had tried -
INSERT INTO "DATA"("NAME","PASSWORD") VALUES ("ABC","PQR"); AND
INSERT INTO "DATA"("NAME","PASSWORD") VALUES (ABC,PQR); .....BUT both are not working.Error comes like ...."The given command is not a SELECT statement.Only queries are allowed."
Both columns has Data Type Varchar. If possible pl provide me ur mail id ,i shall send u snap shots.
Pl help.

Gautam

Hi Gautam

You need to enter this type of SQL using Tools > SQL. I guess you are entering it as a stored 'Query', which has to be a SELECT.

If you need to find my email address, click on my name above, then on 'Overview'.

Tony

Hi Tony,
   I had tried to execute through Tools > SQL. But unfortunately its giving same error.Oh god! pl help me....You'll get snaps on ur mail.Have a look.

Gautam Tarade

Hi Gautam

This is what you need:

INSERT INTO "DATAA" ("id","name","password") VALUES (1,"ABC","PQR")

Note:

1. Data names are case sensitive
2. You must specify a value for the primary key column

Tony

PS If this answers your question, please mark it as Solved.

Hi Tony,
  I tried above said query but still giving an error like "column not found".
Check snap attached in mail.

Gautam

Hi Gautam

I can't see what is wrong. Is it possible for you to email the whole database to me? Or if there is confidential data in it, make a new data base, with a copy of the DATAA table in it, that still gives this error.

By the way, there are other ways of putting new data into a table. For instance, by making a form to do it, or by typing data into a spreadsheet and copying the data in with Paste > Append.

Tony

Hi Tony,
  I had email u database and HTMl file along some descriptions.

Gautam

Hi Tony,
    Thanks for your reply.The insert query ran successfully but through Tools> SQL.Thanks for your valuable time.

Regards,
Gautam

Thanks Tony Pursell, that solved my question.