Change Ancestry source publish location from Provo to Lehi
I assume you just changed Comments to ActualText in the script and that it worked ok??
I tried that (see below) but it did not work. I got an error saying "no such column: Text"
UPDATE SourceTable
SET Text = ''
WHERE SourceTable.SourceID IN
(
SELECT S.SourceID
FROM SourceTable AS S
JOIN SourceTemplateTable AS ST ON ST.TemplateID = S.TemplateID
WHERE ST.Name GLOB 'Ancestry Record'
AND S.Text != ''
)
Ahhhhh .... I'm getting smarter ........... I looked at the Source Table and figured this out. It worked!
UPDATE SourceTable
SET ActualText = ''
WHERE SourceTable.SourceID IN
(
SELECT S.SourceID
FROM SourceTable AS S
JOIN SourceTemplateTable AS ST ON ST.TemplateID = S.TemplateID
WHERE ST.Name GLOB 'Ancestry Record (cleaned)'
AND S.ActualText != ''
)
simple typo(s) can cause failure or worse.