Re: ConstruitTableFichier (PresqueConstruitTableFichier???)

Posté par esylanA le 21/4/2004 10:12:21

Tu vas pas etre decus du voyage:


SELECT TEMPS.IDTEMPS AS IDTEMPS,
CONTACT.IDCONTACT AS IDCONTACT,
CONTACT.siglsecond AS siglsecond,
CONTACT.VILLE AS VILLE,
COLLABOR.IDCOLLABOR AS IDCOLLABOR,
COLLABOR.NOMCOLL AS NOMCOLL,
COLLABOR.PRECOLL AS PRECOLL,
SOCIETE.IDSOCIETE AS IDSOCIETE,
SOCIETE.NOMsecond AS NOMsecond,
TACHE.NOMTACHE AS NOMTACHE,
TEMPS.date AS date,
TEMPS.HEUREFF AS HEUREFF,
TEMPS.HEURTRAN AS HEURTRAN,
TEMPS.LIBELLE AS LIBELLE,
TEMPS.REPAS AS REPAS,
TEMPS.AUTOROUTE AS AUTOROUTE,
TEMPS.KMEFFEC AS KMEFFEC,
TEMPS.TVAFRAIS AS TVAFRAIS,
TEMPS.AUTFRAIS AS AUTFRAIS,
TEMPS.LIBELLFRAI AS LIBELLFRAI,
TEMPS.IDVEHICULE AS IDVEHICULE,
TEMPS.IDTACHE AS IDTACHE,
TEMPS.IDCOLLABOR AS IDCOLLABOR_TE,
TEMPS.IDMISSION AS IDMISSION,
TEMPS.IDSOCCON AS IDSOCCON,
TEMPS.IDCONINT AS IDCONINT,
TEMPS.IDDETAILLM AS IDDETAILLM
FROM TACHE, TEMPS, COLLABOR, SOCCON, SOCIETE, CONTACT
WHERE TACHE.IDTACHE = TEMPS.IDTACHE
AND COLLABOR.IDCOLLABOR = TEMPS.IDCOLLABOR
AND SOCCON.IDSOCCON = TEMPS.IDSOCCON
AND SOCIETE.IDSOCIETE = SOCCON.IDSOCIETE
AND CONTACT.IDCONTACT = SOCCON.IDCONTACT
AND TEMPS.KMEFFEC > 0
AND TEMPS.date BETWEEN {DateDebut} AND {DateFin}
AND CONTACT.IDCONTACT = {IdentifContact}
ORDER BY IDCONTACT ASC, IDCOLLABOR ASC, IDSOCIETE ASC, date ASC


Je suis pas tres sur que ca va t aider(mais c est gentil de vouloir m aider)

La colonne qu'il ne veut pas afficher et qui m'interesse c est TEMPS.IDTEMPS (La premiere)

NOTE: meme si je la foue a la fin ou au milieu de la liste, ou meme que je fasse un trie dessus il ne me l'affiche tjrs pas!!!!