Hello Dinbandhu,
> Now I am not involved in an import. I already have the database set up
> in Base, and it is not allowing me to set the ID column as auto-number
> in the edit window. I tried following Drew's previous instructions to
> put a command in the SQL window (see below), but it would not accept it
> because the ID column is not set as "REQUIRED" and I do not see anywhere
> where that setting can be accomplished.
Unfortunately, you do not describe what exactly happens ("would not
accept it" leaves a lot of room for guessing), so I can provide some
general comments only.
> Please kindly send me your instruction for how to set the ID Column to
> auto-number. And by the way, I would like to keep the e-mail address
> column as primary key, so that it will not allow any duplicate addresses
> to be entered. I can temporarily change the PK to the ID column in order
> to set up auto-number, but ultimately want to reset the PK to the e-mail
> address column for the above stated reason.
For HSQLDB, if a column is an IDENTITY column (that is, has
auto-increment numbers), it is automatically the primary key. So, I
suggest you drop the PK from the email column, then try again adding an
ID column with "auto-increment" = "yes". If this doesn't work, please
provide more details about how and what you do, and what error messages
you get.
To ensure that no email address is entered twice, you do not need a
primary key: You can add an index to the email column (Tools/Edit
Indexes), and check the "Unique" property of this index. From then on,
the database engine will care for the column values being unique. I'd
say this better serves your purpose.
HTH
Ciao
Frank
PS: When starting a new topic, please do *not* simply reply to another
mail with a completely different topic, but create a new mail instead.
Mail readers which sort mails by threads will then sort your message
into the old topic, which means its more likely people will overlook it.
Thanks.
--
- Frank Schönheit, Software Engineer [EMAIL PROTECTED] -
- Sun Microsystems http://www.sun.com/staroffice -
- OpenOffice.org Base http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
