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 LEFT JOIN doubles ON france.dallay= doubles.dallay and no_adherent = #session.NoMembre#) LEFT JOIN cotations2001 ON france.dallay=cotations2001.dallay
Where 0=0
and rubrique='#catid#' and (designation like '%#Motcle#%' or designationcourt like '%#Motcle#%' or france.dallay like '%#Motcle#%'
or valeurfaciale like '%#Motcle#%' or couleurs like '%#Motcle#%') and france.dallay= '#trim(Catid)##Dallay#'
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
cotations2001, France LEFT JOIN doubles ON france.dallay= doubles.dallay and no_adherent = #session.NoMembre#
Where 0=0 and france.dallay=cotations2001.dallay
and rubrique='#catid#' and (designation like '%#Motcle#%' or designationcourt like '%#Motcle#%' or france.dallay like '%#Motcle#%'
or valeurfaciale like '%#Motcle#%' or couleurs like '%#Motcle#%') and france.dallay= '#trim(Catid)##Dallay#'
order by ordre
SELECT libellerubrique from rubriques
Where coderubrique='#catid#'