Re: Base dosn't support INSERT?

"Heikki Tuhkanen" <[email protected]>
Newsgroups gmane.comp.openoffice.dba.user
Message-ID <[email protected]>
Let's try again...

Ok, sorry my incompleatness.

I'm using Ooo 2 beta, exatly 1.9.125 and embedded HSQLDB suppose (came with
the package) on Xp and win 98.
SELECT queries are running well.

If I don't run SQL comman directly, error mes. are:
"SQL Status: HY000
Error code: 1000
The given command is not a SELECT statement.
Only queries are allowed. "
"SQL Status: HY000
Error code: 1000
INSERT INTO "testi" ( "ID", "a", "b" ) VALUES ( 2, "Hoo", "Foo" )"

If I run SQL diretly:
"The data content could not be loaded."
"SQL Status: 00000
Error code: -155
Statement does not generate a result set"

Heikki
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.