Re: table et requete sql | Sujet: Re: table et requete sql par yoh76710 sur 15/11/2005 8:58:35
merci de cette aide pour le moment ma requete est
//selection des champs a afficher
cCondition="Select T_COMMUNE.code_cp_commune AS code_postal , T_COMMUNE.libelle_commune AS ville , T_RESPONSABLE.raison_social_resp AS raison_social ,T_MANIF.jour_debut_manif AS jour_debut"
cCondition+=" , T_MANIF.jour_fin_manif AS jour_fin ,T_RESPONSABLE.tel_resp AS tel_resp , T_COMMUNE.tel_commune AS tel_commune , T_MANIF.type_exposant_manif AS type_exposant "
cCondition+=", T_MANIF.date_ante_manif AS date_ante FROM T_MANIF,T_COMMUNE,T_RESPONSABLE WHERE "
//date debut et date fin
SI DateDebut<>"" ET DateFin<>"" ALORS
cCondition+="jour_debut_manif between '"
cCondition+=DateDebut
cCondition+= "' AND '"
cCondition+=DateFin
cCondition+="' AND "
cCondition+="jour_fin_manif between '"
cCondition+=DateDebut
cCondition+="' AND '"
cCondition+=DateFin
cCondition+="'"
ElementRequete=Vrai
SINON SI DateDebut<>""
cCondition+="jour_debut_manif ='"
cCondition+=DateDebut
cCondition+="'"
ElementRequete=Vrai
SINON SI DateFin <>""
cCondition+="jour_fin_manif = "
cCondition+=DateFin
cCondition+="'"
ElementRequete=Vrai
FIN
//date definie
SI ComboDateDefinie..ValeurAffichée="non" ALORS
ElementRequete=Vrai
SI cCondition<>"" ALORS cCondition+= " AND "
cCondition+="jour_debut_manif ='01/01/****'"
FIN
//type d'exposant
SI ComboTypeExposant <> "" ALORS
SI cCondition<>"" ALORS cCondition+= " AND "
cCondition+="type_exposant_manif ='"
cCondition+=ComboTypeExposant..ValeurAffichée
cCondition+="'"
FIN
//commune de manifestation
SI LieuManif<>"" ALORS
SI cCondition<>"" ALORS cCondition+= " AND "
ElementRequete=Vrai
cCondition+="libele_commune LIKE '*"
cCondition+=LieuManif
cCondition+="'"
FIN
//tel du responsable
SI TelResp<>"" ALORS
SI cCondition<>"" ALORS cCondition+= " AND "
ElementRequete=Vrai
cCondition+="tel_resp ='"
cCondition+=TelResp
cCondition+="'"
FIN
//code postal ville manif
SI CodePostalManif<>"" ALORS
SI cCondition<>"" ALORS cCondition+= " AND "
ElementRequete=Vrai
cCondition+="code_cp_commune like '*"
cCondition+=CodePostalManif
cCondition+="'"
FIN
//nom du responsable
SI ResponManif<>"" ALORS
SI cCondition<>"" ALORS cCondition+= " AND "
ElementRequete=Vrai
cCondition+="nom_resp like '*"
cCondition+=ResponManif
cCondition+="*'"
FIN
//raison social
SI RaisonSocial<>"" ALORS
SI cCondition<>"" ALORS cCondition+= " AND "
ElementRequete=Vrai
cCondition+="raison_social_resp like '*"
cCondition+=RaisonSocial
cCondition+="*'"
FIN
//execution de la reqete
SI ElementRequete=Vrai ALORS
SI cCondition<>"" ALORS cCondition+= " AND "
cCondition+="T_MANIF.id_manif=T_COMMUNE.code_insee_commune AND T_MANIF.id_resp_manif=T_RESPONSABLE.id_resp"
HExécuteRequêteSQL(ReqRechercheManif,hRequêteDéfaut,cCondition)
ElementRequete=Faux
FIN
j'ai affiner ma recherche en metant les champs que je cherchait au lieu de l'étoile
merci de ton aide
|
|
Connexion
Menu
Chercher WDForge
Chercher Web
Partenaires
|