In fact I am using 2.4.1 and my table has a primary key which I can't figure out why has lost count with the real record increment i.e entering record # 20 and the primary key shows 30 or so. I change it manually to correspond with the record but reverts to the original count when entering a new record.
> Date: Mon, 15 Sep 2008 13:52:16 -0500 > From: [EMAIL PROTECTED] > To: [email protected] > Subject: Re: [users] OOo database > > Joe Grech wrote: > > BTW the self copied 6-way up record returned that's why I tried to delete > > it to no avail! > > > > > >> From: [EMAIL PROTECTED] > >> To: [email protected] > >> Date: Mon, 15 Sep 2008 14:33:53 +0200 > >> Subject: [users] OOo database > >> > >> > >> > >> Hi, > >> I am realizing how much database is still in its infancy! It is doing all > >> sorts of funny things. I tried to "copy" a record by ctrl +c and paste by > >> ctrl+v which it did OK. When I pressed Enter to go to the next it copied > >> a record 6 records up and froze. Let me delete it but nothing else. Rt > >> clk on its "empty" space or anywhere in the records shows "copy" and > >> nothing happens. > >> Later on when trying to find a solution the original 'pasted' record > >> copied itself for the second time and then froze again. Clk on a record > >> the cursor disappears and clk again it reappears without letting me do > >> anything. > >> Furthermore the copied one of 6 way up couldn't be deleted not even by > >> highlighting it and press delete. It asks whether I wish to delete but > >> there it stays for keeps! > >> Anything I can do? I wouldn't like going back to Access (ugh). > > Joe, what version of OOo are you using? In 2.4.1, I see no way to copy > or paste a whole record, so I can't recreate this situation. But unless > your table has no primary key, a duplicate record should not be accepted > into the database at all; you should get an error message that it can't > store the record. And having no primary key is a *very* bad idea, odd > behavior with such a table would not be at all surprising. Really, I > think that any attempt to create such a table, or use it via a > connection, should fail; I tried that when I first started using Base, > and ran into a multitude of data integrity problems. > > As I've described before, the only way I know to duplicate (most of) a > record is field by field, and the primary key field can't be > successfully duplicated. > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > _________________________________________________________________ Connect to the next generation of MSN Messenger http://imagine-msn.com/messenger/launch80/default.aspx?locale=en-us&source=wlmailtagline
