[dba-issues] [Issue 53873] Create table Wizard: Auto increment settings do not work with HSQL

2006-06-07 Thread clu
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=53873


User clu changed the following:

  What|Old value |New value

Status|RESOLVED  |CLOSED





--- Additional comments from [EMAIL PROTECTED] Wed Jun  7 08:45:43 -0700 
2006 ---
seems to be fixed = close

please do not hestitate to reopen this issue if still occure in current version

-
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]



[dba-issues] [Issue 53873] Create table Wizard: Auto increment settings do not work with HSQL

2005-09-14 Thread msc
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=53873


User msc changed the following:

  What|Old value |New value

Status|NEW   |RESOLVED

Resolution|  |WORKSFORME





--- Additional comments from [EMAIL PROTECTED] Wed Sep 14 01:57:18 -0700 
2005 ---
set to WORKSFORME.

-
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]



[dba-issues] [Issue 53873] Create table Wizard: Auto increment settings do not work with HSQL

2005-09-13 Thread msc
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=53873





--- Additional comments from [EMAIL PROTECTED] Tue Sep 13 04:55:25 -0700 
2005 ---
Hi,

the version m128 available under http://download.openoffice.org/680/index.html
has no problem to do these thing.

The IDENTITY string is automatic insert when you use autovalue on the second
screen.
When you use the 3. screen to create a autovalue primary key there is also no
problem.

msc - kieser: can you please test it with a m128.

Thanks  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]



[dba-issues] [Issue 53873] Create table Wizard: Auto increment settings do not work with HSQL

2005-08-30 Thread regina
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=53873


User regina changed the following:

  What|Old value |New value

Ever confirmed|  |1

Status|UNCONFIRMED   |NEW

  Keywords|needmoreinfo, oooqa   |oooqa





--- Additional comments from [EMAIL PROTECTED] Mon Aug 29 23:16:02 -0700 
2005 ---
In 1.9.125 IDENTITY is missing for HSQL data base engine when setting AutoValue
in third step of wizard and not in second step.

-
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]



[dba-issues] [Issue 53873] Create table Wizard: Auto increment settings do not work with HSQL

2005-08-30 Thread kieser
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=53873





--- Additional comments from [EMAIL PROTECTED] Tue Aug 30 03:06:03 -0700 
2005 ---
Okay so the fix is simply to add it in screen 3 then. Cool.

-
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]



[dba-issues] [Issue 53873] Create table Wizard: Auto increment settings do not work with HSQL

2005-08-29 Thread regina
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=53873





--- Additional comments from [EMAIL PROTECTED] Mon Aug 29 15:07:48 -0700 
2005 ---
So this issue can be closed?

-
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]



[dba-issues] [Issue 53873] Create table Wizard: Auto increment settings do not work with HSQL

2005-08-29 Thread kieser
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=53873





--- Additional comments from [EMAIL PROTECTED] Mon Aug 29 17:11:22 -0700 
2005 ---
No. OO should not allow you to leave the value blank if it's in HSQL! Else you
get an error that to a user is rather severe and they won't know what to do 
with it.

Either:
The IDENTITY type should be added automatically if you choose the
auto-increement on the third screen and it should NOT rely on this being
populated in the second screen...

OR

... OO should detect the error and put up a meaningful message when it comes to
tbale create time (tricky to do... this isn't really a solution)

OR

... On the third screen, if you choose Auto-increment, OO should either take you
back to the 2nd screen telling you to fill in the field (and helpfully default
this to IDENTITY if the DB is HSQL) or else at least put a popup up saying
that the auto increment text is missing and please go back to screen 2 to fill
it in... and then say HINT: Use IDENTITY for HSQL databases.

THe last is probably the most likely to be able to be implemented and the most
workable.


-
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]



[dba-issues] [Issue 53873] Create table Wizard: Auto increment settings do not work with HSQL

2005-08-28 Thread regina
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=53873


User regina changed the following:

  What|Old value |New value

CC|''|'regina'

  Keywords|  |needmoreinfo, oooqa





--- Additional comments from [EMAIL PROTECTED] Sun Aug 28 14:39:59 -0700 
2005 ---
I use version 1.9.125 on WinXP. I have no problems. Setting AutoValue to Yes
generates Auto-increment statement IDENTITY.
Which version do you use? Please try the newest version.

-
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]



[dba-issues] [Issue 53873] Create table Wizard: Auto increment settings do not work with HSQL

2005-08-28 Thread kieser
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=53873





--- Additional comments from [EMAIL PROTECTED] Sun Aug 28 15:08:59 -0700 
2005 ---
I am on 113 on Linux. Will try latest version and test but you MUST be using the
wizard as I stated. 

Just to be sure of the steps because there are several routes to creating
auto-increment columns:

1) Start wizard
2) Choose a table (I chose invoices).
3) Select columns (I chose all the columns)
4) CLick Next
5) Click Next again
6) Choose Use existing field as primary key and a column to be a key (I chose
InvoiceID).
7) Check auto value
8) Click next
9) Give a new table name and save in PUBLIC schema.
10) Click Finish.

The error pops up.

-
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]



[dba-issues] [Issue 53873] Create table Wizard: Auto increment settings do not work with HSQL

2005-08-28 Thread kieser
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=53873





--- Additional comments from [EMAIL PROTECTED] Sun Aug 28 15:11:23 -0700 
2005 ---
Latest linux build available is only 122... so I can't test on 125.
Downloading 122 and testing.

-
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]



[dba-issues] [Issue 53873] Create table Wizard: Auto increment settings do not work with HSQL

2005-08-28 Thread kieser
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=53873





--- Additional comments from [EMAIL PROTECTED] Sun Aug 28 18:10:02 -0700 
2005 ---
Okay I think I see the problem here. If you don't put in the keyword IDENTITY
on the second screen (the auto-increment statement) this is when you get the
problem. However, if you do put this in, then the table generates fine.


-
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]