Thanks Brian, I don't know how I did it, but following your advice I've achieved what I wanted to achieve.
Brian Barker wrote: > > At 16:40 17/04/2008 -0700, Kafka Noname wrote: >>Barbara Duprey wrote: >>>kafka1 wrote: >>>>I have created a table containing my music collection by importing >>>>an Excel Spreadsheet. After a lot of trial and error, almost >>>>everything is working fine, however when I create a new record I >>>>have to manually enter a number in the ID (Primary key) field. >>>>This is a bit of a nuisance as it means I have to determine the ID >>>>number of the last record. I have done what has been suggested in >>>>another forum, i.e. set the AutoValue for ID to Yes, however all >>>>that happens that a zero is placed in the ID field. It was also >>>>suggested that I set the Auto-increment statement to IDENTITY, >>>>however I don't have that option in Field properties. >>>> >>>>I have also typed ALTER TABLE "Table1" ALTER COLUMN "ID" IDENTITY >>>>in the SQL window, but without success. Is there any other way I >>>>can have the ID automatically insert the next number? >>> >>>I've had the best luck with this kind of thing by defining a new >>>table with all the fields as needed, including an auto-increment >>>primary key field, and then appending the data from the existing >>>table (leaving out the manually generated key). After that, the >>>original table can be discarded, and new records get the right key >>>automatically. Even when >>>I'm working inside a query that is a subset of the data and not >>>sorted by the key; I can go to the last record and add a record, >>>and it uses the next available record number for the table. >> >>Thanks Barbara, >> >>I'm only new to this, and while your advice makes sense, I am >>embarrassed to say that I haven't been able to append data to the >>new table. I've tried copying and pasting from the original table >>but that only pastes the data from the first field. OpenOffice help >>doesn't really help because it refers to functions I can't locate. I >>am guessing that it's really simple if you know which buttons to press. > > You may - understandably - be opening the new table before trying to > paste into it. Don't do this. Instead, work in the Tables panel of > the database. Either drag the icon for the old table over the new > one, or use Copy and Paste to do the same thing - with the table > icons, that is. Either way, this brings up the "Copy table" dialogue, > one option of which is "Append data". > > I trust this helps. > > Brian Barker > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > -- View this message in context: http://www.nabble.com/Auto-increment-ID-in-a-database-tp16698582p16760357.html Sent from the openoffice - users mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
