1 Topic by ser

  • ser
  • ser
  • Administrator
  • Offline
  • From: Staffordshire Ecological Recor
  • Registered: 24-09-2008
  • Posts: 603

Topic: Problem with addresses for contacts

I think I have broken my copy of Recorder :(

When I add an address to an individual or organisation, once it is saved, it becomes read-only, i.e. it cannot be edited - I have located the problem, the CUSTODIAN field of the address is not being populated, it is NULL, so Recorder 'sees' the address as 'owned' by another copy of Recorder, populating it by hand fixes the problem, but I don't know what I've done to lose this basic function!

Craig

Craig Slawson
Staffordshire Ecological Record

ser's Website

2 Reply by MikeWeideli

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

Re: Problem with addresses for contacts

You may have lost the trigger on this table (hopefully no others). Try running the following

EXEC spCreateCustodianTrigger 'ADDRESS', 'ADDRESS_KEY'

It might also be worth checking that your site id is still in the setting table and is correct.

Mike Weideli

MikeWeideli's Website

3 Reply by ser

  • ser
  • ser
  • Administrator
  • Offline
  • From: Staffordshire Ecological Recor
  • Registered: 24-09-2008
  • Posts: 603

Re: Problem with addresses for contacts

Cheers Mike, that appears to have fixed the problem

Ta

Craig

Craig Slawson
Staffordshire Ecological Record

ser's Website