create sql view cc_cce remote connection 'm project' as
select cce.*, description1 from cce, payment where
cce.cce_payment=payment.payment_no and cce_payment is not null and cast
(convert(char(10), date_accept,111) as datetime)=?Filter_CC_date ;
union select cce.*, 'Paiement différé' as description1 from cce where
cce_payment_transfer is not null and cast(convert(char(10),
date_accept,111) as datetime)=?Filter_CC_date