Re: Re: Base dosn't support INSERT?

Andrew Jensen <[email protected]>
Newsgroups gmane.comp.openoffice.dba.user
Message-ID <[email protected]>
Oh and in the statement HSQL it is single quotes for strings and double 
quotes for Object names

(2, 'Hoo', 'Foo' ) not (2, "Hoo", "Foo")

The second version will generate the error, COLUMN NOT FOUND

Drew


Heikki Tuhkanen wrote:

>INSERT INTO "testi" ( "ID", "a", "b" ) VALUES ( 2, "Hoo", "Foo" )"
>
>
>
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: [email protected]
>For additional commands, e-mail: [email protected]
>
>
>
>  
>
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.