SELECT manques.neuf,manques.nac,manques.nsg, manques.oblitere, manques.surlettre, france.dallay, france.designationcourt, france.valeurfaciale, france.couleurs from manques, france
where manques.dallay= france.dallay and no_adherent = #session.NoMembre#
and (designation like '%#Motcle#%' or designationcourt like '%#Motcle#%' or france.dallay like '%#Motcle#%'
or valeurfaciale like '%#Motcle#%' or couleurs like '%#Motcle#%')
order by ordre
Update manques set neuf=#LNSC#, nac=#LNAC#, nsg=#LNSG#, oblitere=#LOblitere#, surlettre=#LSurlettre#
Where no_adherent=#Session.NoMembre# and dallay='#qTimbres2.dallay#'
Insert into manques (no_adherent, dallay, neuf, nac, nsg, oblitere, surlettre)
VALUES (#Session.NoMembre#, '#qTimbres2.dallay#', #LNSC#, #LNAC#, #LNSG#, #LOblitere#, #LSurlettre#)
Delete from manques where dallay='#Dallay#' and no_adherent = #session.NoMembre#
Philatélix
SELECT * FROM profils where nochrono=#Session.NoMembre#
SELECT manques.neuf, manques.nac, manques.nsg, manques.oblitere, manques.surlettre, france.dallay, france.designationcourt, france.valeurfaciale, france.couleurs ,
cotations2001.neuf as cot_nsc, cotations2001.neufaveccharniere as cot_nac, cotations2001.nsg as cot_nsg, cotations2001.oblitere as cot_obli, cotations2001.lettre as cot_surl
from manques, france, cotations2001
where manques.dallay= france.dallay and cotations2001.dallay=france.dallay and no_adherent = #session.NoMembre#
and (designation like '%#Motcle#%' or designationcourt like '%#Motcle#%' or france.dallay like '%#Motcle#%'
or valeurfaciale like '%#Motcle#%' or couleurs like '%#Motcle#%')
order by ordre