Re: Base dosn't support INSERT?
Wolfgang Schaible <[email protected]>
| Newsgroups | gmane.comp.openoffice.dba.user |
|---|---|
| Organization | atHome |
| Message-ID | <[email protected]> |
hi Heikki,
Am Sonntag 04 September 2005 22.32 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)
>
<>
> Am I just simple?
Dont know but your question is not easy to answer :-)
Do you have a connection, a statement and executeUpdate used?
Syntax:
oStmt.executeUpdate("INSERT INTO SALES " +
"VALUES (4, 102, 5, 'FTOP Darjeeling tea', '2002-01-02',150)");
Wolfgang