SELECT * FROM profils where nochrono=#Session.NoMembre#
DELETE from manques
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
INSERT into manques (no_adherent, dallay, neuf, nac, nsg, oblitere, surlettre)
values (#session.NoMembre#, '#vDallay#', #numberformat(NSC)#, #numberformat(NAC)#, #numberformat(NSG)#, #numberformat(OBLI)#, #numberformat(SURL)#)
Philatélix