Re: Re: Base dosn't support INSERT?

"Heikki Tuhkanen" <[email protected]>
Newsgroups gmane.comp.openoffice.dba.user
Message-ID <[email protected]>
Ok, thanks - that worked.
It still doesn't work in query-window, but perhaps in next version:)

Hoo

"Andrew Jensen" <[email protected]> kirjoitti 
viestissä:[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.