Can anyone see why this is not working from On Server Event of Button.
$record = $button->getCurrentRecord();
$sql = "INSERT INTO pgmanagement_dbs.tblClientTabV2(ClientName,
SwitchboardPhone)
SELECT Company Name, Phone Number FROM pgmanagement_dbs.tblprospectdataV2
WHERE Unique ID=" . $record['Unique ID'];