DELETE from doubles
where no_adherent=#session.NoMembre#
Select chg_nouveau from changements_numeros where
chg_version = '1' and chgt_type ='' and chg_ancien='#vDallay#'
order by chgt_type,chg_version,chg_ancien
Select chg_nouveau from changements_numeros where
chg_version = '2' and chgt_type ='' and chg_ancien='#vDallay#'
order by chgt_type,chg_version,chg_ancien
Select chg_nouveau from changements_numeros where
chg_version = '2a' and chgt_type ='' and chg_ancien='#vDallay#'
order by chgt_type,chg_version,chg_ancien
Select chg_nouveau from changements_numeros where
chg_version = '3' and chgt_type ='' and chg_ancien='#vDallay#'
order by chgt_type,chg_version,chg_ancien
Select chg_nouveau from changements_numeros where
chg_version = '4' and chgt_type ='' and chg_ancien='#vDallay#'
order by chgt_type,chg_version,chg_ancien
Select chg_nouveau from changements_numeros where
chg_version = '5' and chgt_type ='' and chg_ancien='#vDallay#'
order by chgt_type,chg_version,chg_ancien
Select chg_nouveau from changements_numeros where
chg_version = '6' and chgt_type ='' and chg_ancien='#vDallay#'
order by chgt_type,chg_version,chg_ancien
Select chg_nouveau from changements_numeros where
chg_version = '7' and chgt_type ='' and chg_ancien='#vDallay#'
order by chgt_type,chg_version,chg_ancien
Select chg_nouveau from changements_numeros where
chg_version = '8' and chgt_type ='' and chg_ancien='#vDallay#'
order by chgt_type,chg_version,chg_ancien
Select chg_nouveau from changements_numeros where
chg_version = '9' and chgt_type ='' and chg_ancien='#vDallay#'
order by chgt_type,chg_version,chg_ancien
Select chg_nouveau from changements_numeros where
chg_version = '10' and chgt_type ='' and chg_ancien='#vDallay#'
order by chgt_type,chg_version,chg_ancien
Select chg_nouveau from changements_numeros where
chg_version = '11' and chgt_type ='' and chg_ancien='#vDallay#'
order by chgt_type,chg_version,chg_ancien
Select chg_nouveau from changements_numeros where
chg_version = '12' and chgt_type ='' and chg_ancien='#vDallay#'
order by chgt_type,chg_version,chg_ancien
Select chg_nouveau from changements_numeros where
chg_version = '13' and chgt_type ='' and chg_ancien='#vDallay#'
order by chgt_type,chg_version,chg_ancien
INSERT into doubles (no_adherent, dallay, neufs_sc, neufs_ac, neufs_sg, obliteres, surlettre)
values (#session.NoMembre#, '#vDallay#', #numberformat(NSC)#, #numberformat(NAC)#, #numberformat(NSG)#, #numberformat(OBLI)#, #numberformat(SURL)#)
Philatélix