Re: Re: Base dosn't support INSERT?

 From the main window of Base select Tools->SQL

Now type your insert statement in to the SQL window and execute it.

That should do the trick

Drew

Heikki Tuhkanen wrote:

>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
>
>
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: [email protected]
>For additional commands, e-mail: [email protected]
>
>
>
>  
>