IF select count(*) from DEBAPPOINTMENT where WEXTID = '<@APTNUM@>'
@@GO@@
INSERT INTO DEBAPPOINTMENT
 (WDEPAPPOINTMENTID, WACCOUNTID, DDATE, SNOTES, WEXTID)
 VALUES (gen_id(gen_debappointment,1),<@WACCOUNTID@>,
<@APTDATETIME@>,
'<@NOTE@>',
'<@APTNUM@>') 
@@GO@@
update DEBAPPOINTMENT
set WACCOUNTID = <@WACCOUNTID@>,
 DDATE= <@APTDATETIME@>,
 SNOTES = '<@NOTE@>'
 where WEXTID = '<@APTNUM@>'
@@GO@@ 