On Thu, 26 Jan 2012 16:50:55 +1100, Tony Rolfe
<[email protected]> wrote:
>I don't suppose there is anyone clever enough to show me the SQL?
>Ideally, in two separate bits - one to set the tags and the other to do
>the search and replace?
The tagging can be done with Legacy using its Advanced Tagging feature.
Let's assume you use Tag9.
As far as the SQL is concerned, first use MS Access or LTools or
whatever to look up "Australia" in tblLR. Write down the value of IDLR.
Then, after closing Legacy and backing up your database, run the
following UPDATE query...
UPDATE tblIR SET tblIR.IDLRBirth = {IDLR}
WHERE ((tblIR.Tag9=1) AND (tblIR.IDLRBirth=1) AND (tblIR.IDLRChris=1)
AND (tblIR.IDIR<>0))
Where it says {IDLR} substitute the value you got from looking up
"Australia" in tblLR. Change Tag9 if you used a different Tag#.
>Would it be possible using the raw SQL feature of LTools?
Yes. Make sure you backup your Legacy database first, no matter which
tool you use.
--
Dennis Kowallek (LTools/Custom Programming)
http://zippersoftware.com/ltools/index.htm
http://groups.yahoo.com/group/ltools
NOTE TO LUG USERS: Use plain text if you want me to read your post.
Legacy User Group guidelines:
http://www.LegacyFamilyTree.com/Etiquette.asp
Archived messages after Nov. 21 2009:
http://www.mail-archive.com/[email protected]/
Archived messages from old mail server - before Nov. 21 2009:
http://www.mail-archive.com/[email protected]/
Online technical support: http://www.LegacyFamilyTree.com/Help.asp
Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our
blog (http://news.LegacyFamilyTree.com).
To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
