To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=42610
Issue #:|42610
Summary:|Base gives cryptic error message when autonumber is
|selected
Component:|Database access
Version:|680m77
Platform:|PC
URL:|
OS/Version:|Windows 2000
Status:|UNCONFIRMED
Status whiteboard:|
Keywords:|
Resolution:|
Issue type:|DEFECT
Priority:|P3
Subcomponent:|none
Assigned to:|msc
Reported by:|vreid47362
------- Additional comments from [EMAIL PROTECTED] Sat Feb 12 05:18:05 -0800
2005 -------
The database application gives the following error message:
"Error while connecting to the data source
Wrong data type: jobid in statement [CREATE TABLE "Table2"
("jobid" NUMERIC(50) NOT NULL IDENTITY)"
I received this message while creating a new table in the new native OpenOffice
Database. I had picked a data type of numeric for a field, set it to
auto-number, and set it as the primary key when I got this error message.
After receiving this error message, I was able to change the data type to bigint
and with auto-numbering and set it as primary key and OpenOffice then created
the table.
If the new OpenOffice database application cannot create auto-number primary
keys with a data type of numeric, then the error message needs to be less
cryptic and better explain what is going on. For example, an error message with
wording similar to the following would be much easier for an office worker to
understand: "You have chosen options that the OpenOffice database cannot
implement. Please choose an integer data type if you wish to use auto-numbering
with a primary key."
If this is an error in the database application, it needs to be fixed because I
think most people will choose numeric as an auto-number primary key.
---------------------------------------------------------------------
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]
