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]
