1 Topic by HarryClarke

  • HarryClarke
  • Veteran
  • Offline
  • From: Surrey
  • Registered: 11-10-2011
  • Posts: 99

Topic: Adding new Individual not updating last key

When a new individual is added in Names & Addresses. The Last Key for the Individual is not updated.
The following steps are repeatable
1) Dump of table "Last Key"
2) Add new individual
3) Dump of table "Last Key"
4) Run Update Last Key
5) Dump of table "Last Key"
6) Check for differences.

The last key in the Name table is correctly updated. However, the last key in the Individual table is not updated at Step 3, and is only updated when step 4 is performed.

TABLE_NAME    LastKey1    LastKey3    LastKey5
INDIVIDUAL    000008OJ    000008OJ    000008OK
NAME            000008OJ    000008OK    000008OK

Harry Clarke
Surrey County Butterfly Recorder

2 Reply by MikeWeideli

  • MikeWeideli
  • Administrator
  • Offline
  • From: Littlefield Consultancy
  • Registered: 05-07-2006
  • Posts: 2,625

Re: Adding new Individual not updating last key

Hi

The individual table doesn't even need to be in last key and it certainly doesn't matter if it is there and not up to date. You will see that the primary key is Name_Key and this is always obtained form table Name and not the Individual table. The table is only in Last Key, because the Update Last key software adds it  when it isn't required. You don't need to run last key again unless you get a problam.

Mike Weideli

MikeWeideli's Website