Oh and in the statement HSQL it is single quotes for strings and double quotes for Object names

(2, 'Hoo', 'Foo' ) not (2, "Hoo", "Foo")

The second version will generate the error, COLUMN NOT FOUND

Drew


Heikki Tuhkanen wrote:

INSERT INTO "testi" ( "ID", "a", "b" ) VALUES ( 2, "Hoo", "Foo" )"





---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to