Maybe it was my fault after all cos I have succeeded in highlighting the fields one at a time (not the primary key but) and copy and paste in a new entry. It seems that this is a solution after all! Oh yes my primary key was set by base itself.
> Date: Tue, 16 Sep 2008 08:32:53 -0500 > From: [EMAIL PROTECTED] > To: [email protected] > Subject: Re: [users] OOo database > > That's because you've deleted records. Each new record gets the next > number that has not been assigned before, so there is no reason to > expect the displayed line indicator and the key field to contain the > same value. (The displayed line indicators are not the record numbers -- > in a sorted query, for example, they still are sequential starting with > 0 regardless of the position of the records in the database.) When you > have an auto-value key, that means you have no manual control over it, > it is set only by Base. I'm really puzzled about exactly what you did to > copy and paste a record, I see no way to even attempt that. When I > select a record by clicking its line indicator, and Ctrl-C, the > clipboard contains only a single field's value, and it can't be pasted > without selecting a field. So I don't understand how you got tangled up > with duplicated records in the first place. What exactly did you do? > > Joe Grech wrote: > > 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] > _________________________________________________________________ News, entertainment and everything you care about at Live.com. Get it now! http://www.live.com/getstarted.aspx
