SELECT france.dallay, france.designationcourt, france.valeurfaciale, france.couleurs, doubles.neufs_sc, doubles.neufs_ac, doubles.neufs_sg, doubles.obliteres, doubles.surlettre, cotations2001.neuf, cotations2001.neufaveccharniere, cotations2001.nsg, cotations2001.oblitere, cotations2001.lettre
FROM france, doubles, cotations2001
Where france.dallay= doubles.dallay and france.dallay=cotations2001.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 doubles SET neufs_sc=#numberformat(evaluate("form.NSC"&Dallay1))#,neufs_ac=#numberformat(evaluate("form.NAC"&Dallay1))#,
neufs_sg=#numberformat(trim(evaluate("form.nsg"&Dallay1)))#,obliteres= #numberformat(trim(evaluate("form.Obli"&Dallay1)))#, surlettre=#numberformat(trim(evaluate("form.SurL"&Dallay1)))#
Where no_adherent=#Session.NoMembre# and dallay='#qTimbres2.dallay#'
Delete from doubles where dallay='#Dallay#' and no_adherent = #session.NoMembre#
Insert into doubles (no_adherent, dallay, neufs_sc, neufs_ac, neufs_sg, obliteres, surlettre)
VALUES (#Session.NoMembre#, '#Dallay#', #numberformat(trim(evaluate("form.NSC"&Dallay1)))#,#numberformat(trim(evaluate("form.NAC"&Dallay1)))#, #numberformat(trim(evaluate("form.nsg"&Dallay1)))#, #numberformat(trim(evaluate("form.Obli"&Dallay1)))#,#numberformat(trim(evaluate("form.SurL"&Dallay1)))#)
Philatélix
SELECT * FROM profils where nochrono=#Session.NoMembre#
SELECT france.dallay, france.designationcourt, france.valeurfaciale, france.couleurs, doubles.neufs_sc, doubles.neufs_ac, doubles.neufs_sg, doubles.obliteres, doubles.surlettre, cotations2001.neuf, cotations2001.neufaveccharniere, cotations2001.nsg, cotations2001.oblitere, cotations2001.lettre
FROM france, doubles, cotations2001
Where france.dallay= doubles.dallay and france.dallay=cotations2001.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