The tune is normally used the link in a "waltz country dance" medley. You don't hear those all that often now, but they are still part of the ceilidh band repertoire.

It's basically "Ach du lieber Augustin", isn't it? What tune did Hogg say to use? (This browser doesn't display Google Books pages).