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 themesassocies
RIGHT JOIN (doubles RIGHT JOIN (france RIGHT JOIN cotations2001 ON france.dallay=cotations2001.dallay) ON france.dallay= doubles.dallay and doubles.no_adherent = #session.NoMembre#) ON themesassocies.dallay= france.dallay
Where themesassocies.Theme=#Theme#
and (france.designation like '%#Motcle#%' or france.designationcourt like '%#Motcle#%' or france.dallay like '%#Motcle#%'
or france.valeurfaciale like '%#Motcle#%' or france.couleurs like '%#Motcle#%')
Order by france.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 themesassocies
RIGHT JOIN (doubles RIGHT JOIN (france RIGHT JOIN cotations2001 ON france.dallay=cotations2001.dallay) ON france.dallay= doubles.dallay and doubles.no_adherent = #session.NoMembre#) ON themesassocies.dallay= france.dallay
Where themesassocies.Theme=#Theme#
and (france.designation like '%#Motcle#%' or france.designationcourt like '%#Motcle#%' or france.dallay like '%#Motcle#%'
or france.valeurfaciale like '%#Motcle#%' or france.couleurs like '%#Motcle#%')
Order by france.ordre
