Re: Base dosn't support INSERT?

"Wolfgang Schaible" <[email protected]> kirjoitti 
viestissä:[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)");
>
No, I'm running SQL directly in OOo 2 beta odb database.