Re: Base dosn't support INSERT?

Marc Santhoff <[email protected]>
Newsgroups gmane.comp.openoffice.dba.user
Message-ID <[email protected]>
Am Sonntag, den 04.09.2005, 23:32 +0300 schrieb Heikki Tuhkanen:
> Hi, I'm just fresh user:) and my simple SQL- sentence won't work with
> my simple test-table in my simple test-odb-database:
>  
> INSERT INTO testi (ID, a, b)
> VALUES (2, Hoo, Foo)
>  
> Results:
>  
> "The data content could not be loaded.
> SQL Status: 00000
> Error code: -155
>  
> Statement does not generate a result set"

Did the values make it into the table? Not getting a result from INSERT
queries sounds rather normal to me.

Since the status is 0000 that looks okay...

Try opening the table or "SELECT * FROM testi WHERE ID=2".

HTH,
Marc
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.