| Subject | Re: Execute Block: Need Insert Into to trigger Primary Key generator. |
|---|---|
| Author | |
| Post date | 2018-02-27T02:28:42Z |
I also tried:
set term ^ ;
EXECUTE BLOCK AS BEGIN
INSERT INTO ACORD_DATA (FK_ID, D_ACORD_FORM_FIELD_NAME, D_ACORD_FORM_FIELD_TYPE, STR_VALUE) VALUES (973, 'FrmCmplDtA', 'CHAR', '02/26/2018');
INSERT INTO ACORD_DATA (FK_ID, D_ACORD_FORM_FIELD_NAME, D_ACORD_FORM_FIELD_TYPE, STR_VALUE) VALUES (973, 'ProFullNmA', 'CHAR', 'Waterman Agency Inc.');
INSERT INTO ACORD_DATA (FK_ID, D_ACORD_FORM_FIELD_NAME, D_ACORD_FORM_FIELD_TYPE, STR_VALUE) VALUES (973, 'ProMailAddrLn1A', 'CHAR', '1346 A Street');
INSERT INTO ACORD_DATA (FK_ID, D_ACORD_FORM_FIELD_NAME, D_ACORD_FORM_FIELD_TYPE, STR_VALUE) VALUES (973, 'ProMailAddrLn2A', 'CHAR', '');
END^
set term ; ^