| View previous topic :: View next topic |
| Author |
Message |
Peter Rawbone
Joined: 06 Apr 2006
Posts: 10
Location: UK
|
 Posted: Wed Mar 10, 2010 7:06 pm Post subject: Editing Resources etc |
 |
|
Over time I have managed to have several Source Document & Repository duplicates and wish to keep only one.
However, I am a little nervous to do so as I fear that I may remove relevant data. Is the code reference purely a reference or not? I've looked through the help files and whilst they discuss adding sources etc do not appear to give any guidance to remove. 
Regards
Peter |
|
| Back to top |
|
 |
Nick Hunter
Joined: 18 Dec 2005
Posts: 399
Location: SpanSoft, Scotland
|
| Posted: Wed Mar 10, 2010 8:24 pm Post subject: |
|
|
Hi,
If you delete a source document which is referenced by a source in a person or family data form, the source will remain intact but will no longer point at any document.
Before deleting any source documents, it might be wise to run the following SQL query in the Search window:
SELECT *
FROM Sources
ORDER BY Document
Then check if any of these sources are referring to the document (using the code) which you intend to delete.
Similarly check for references between source documents and repositories.
_________________
Regards,
Nick Hunter
 |
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
