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