Campbell, John, active 1794-1808, Major-General