SELECT ShowType_en, ShowTypeColor
FROM ShowType
WHERE Repertoire_No=#attributes.Repertoire_No#
ORDER BY ShowType
SELECT S.ShowID,
S.id_fr,
S.entete_autre as entete,
S.intro_autre as intro,
S.titre_autre as titre,
S.extrait_autre as extrait,
S.description_autre as description,
S.credits,
S.web,
S.lieu,
S.date_debut,
S.date_fin,
S.heure_debut,
S.heure_fin,
S.membre,
S.selechoix,
S.clientstypeid,
ST.ShowType_en,
ST.showtypeid,
ST.ShowTypeColor,
ST.extrait_en as STextrait
FROM horaire S, ShowType ST
WHERE S.ShowTypeID=ST.ShowTypeID#PreserveSingleQuotes(QryChoix)#
AND (S.actif='1'or S.actif='3')
AND S.langue='fr'
AND S.Repertoire_No=#attributes.Repertoire_No##PreserveSingleQuotes(QueryEvent)#
ORDER BY S.date_debut, S.heure_debut,S.Tri,S.Titre
Schedule
#ShowType_en#
#STextrait#
#entete#
#intro#
When
Choice
Description
#LSDateFormat(date_debut,'ddd, d mmm, yy')# #TimeFormat(heure_debut, "h")#:#TimeFormat(heure_debut, "mm")# to #TimeFormat(heure_fin, "h")#:#TimeFormat(heure_fin, "mm")#