Re: [firebird-support] How do you write dynamic sql in Firebird

[dixonepper...@yahoo.com [firebird-support]]

Martijn,
 

 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;
 

 Dixon