← Back to team overview

ubuntuforums-unanswered team mailing list archive

Re: [Question #76481]: insert query in Open office

 

Question #76481 on openoffice.org in ubuntu changed:
https://answers.launchpad.net/ubuntu/+source/openoffice.org/+question/76481

    Status: Open => Answered

Tony Pursell proposed the following answer:
Hi Gautam

This SQL works in the database you sent me:

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

Note:
1. Two column names have spaces after them.
2. Double quotes are for data names (table, columns, etc). String values need single quotes.

When you are embedding SQL into programs and scripts, double quotes (")
often have a special meaning to the programming/script language.  The
SQL is usually a string, so it has to be double quoted for the language
to recognise it as such.  The quotes in the original SQL have to be
doubled, so they don't look like the language's end of string quote, eg

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

I will try and have a look at your macros, but that is not my area of
expertise.

OpenOffice.org has its own forums at

http://user.services.openoffice.org/en/forum/

where you will find lots of help.

Tony

-- 
You received this question notification because you are a member of UF
Unanswered Posts Team, which is an answer contact for Ubuntu.