user: ### NOW ANSWER:
Question: On what date was James P. Buchanan (D)'s successor seated?
Columns: ['District', 'Vacator', 'Reason for change', 'Successor', 'Date successor seated']
Types: ['text', 'text', 'text', 'text', 'text']
Sample row: ['Virginia 3rd', 'Andrew Jackson Montague (D)', 'Died January 24, 1937', 'Dave E. Satterfield, Jr. (D)', 'November 2, 1937']
SQL:

assistant: SELECT "Date successor seated" FROM "Table" WHERE "Vacator" = 'James P. Buchanan (D)';