Hi All

I'd like to run the following SQL from embedded SQL
Code:
/*  0101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;/*  0101 SET NAMES utf8 */;
/*  0503 SET NAMES utf8mb4 */;
/*  0014 Set @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*  0101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;


Insert into `REASONS` (`Recnum`,`CODE`,`DESCRIPTION`,`CHANGED_BY`,`DATE_CHANGED`,`MANUAL_SELECT`) Values 
(1, 1, 'Testing', 'Marco', '2020-09-16', 'Y'),
(2, 2, 'More testing', 'Joseph', '2020-09-16', 'Y');


/*  0101 Set SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*  0014 Set FOREIGN_KEY_CHECKS=If(@OLD_FOREIGN_KEY_CHECKS is NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*  0101 Set CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
Run with send SQLExecDirect does not create any of the records. I was hoping to do this direct, rather than Direct_output then call the SQL.

Any suggestions?

Kind regards
Marco