I am afraid that I have to join the ranks of those who in the past have asked Jim Carroll not to misrepresent what they have said.

It is disappointing that this interesting discussion is to be cut short because Jim had said he had researched this song, and I would have been interested in what he had found out about it.

The song has a Roud number: 98, and a ballad version of it may be seen on the VWML website, easily accessible by googling.

I have learned that it appears in Child because he took it from a collection by Jameson. The latter is online, and is the earliest example I know of assertions that the song is about real people. Jameson took the song down from a stall ballad.

I have learned that people in or on the edge of the folksong world have come up with all sorts of stories about the song, and about the 'true story' which it is sometimes asserted to tell. One example was that Lammie played his trumpet from the towers of Fyvie Castle; another is that there is a statue of him on the castle.