To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=58795
User msc changed the following:
What |Old value |New value
================================================================================
Status|UNCONFIRMED |RESOLVED
--------------------------------------------------------------------------------
Resolution| |WORKSFORME
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Mon Dec 5 01:37:04 -0800
2005 -------
Hi,
I suppose that you are trying to create a new table in a hsql database ( the
default embedded database inside OOo)
In hsql the ` are not valid quote signs.
So you have to use the second sql string with the "" as quote sign. However
there is the problem that hsql wants to have first the default value and then
the NOT NULL token.
The correct SQl strings looks like this.
CREATE TABLE "billing" (
"id" int NOT NULL,
"people_id" varchar(20) default '' NOT NULL ,
"datetime" datetime default '0000-00-00 00:00:00' NOT NULL ,
PRIMARY KEY ("id")
);
Here is the documentation for the "create table" statement
http://www.hsqldb.org/doc/guide/ch09.html#create_table-section
Bye Marc
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
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]
