|Subject||Re: [firebird-support] How do you write dynamic sql in Firebird|
Thanks, ROWS worked perfect
I changed it to this and am getting what I want.
UPDATE tblCampaign a SET
a.BATCHNUM = :BatchNum
WHERE a.CAMPAIGNID IN (SELECT c.CAMPAIGNID
FROM tblCampaign c
WHERE c.CAMPAIGNNAME = :CampaignName
AND c.CONTACTPERMISSION = 'Y'
AND c.BADEMAIL = 'N'
AND c.ABORTCAMPAIGN = 'N'
AND c.BATCHNUM = -1 )ROWS :Cnt;