[REQUETE]
NOM="QRY_Aulas_Activas"
SQL=" SELECT  Aulas.AulasID AS AulasID,	 Aulas.Nombre AS Nombre,	 Aulas.Cupo AS Cupo  FROM  Aulas  WHERE   Aulas.Activo = 1  ORDER BY  Nombre ASC"
ARBRE="/* Génération automatique de l'abre de la requête QRY_Aulas_Activas */ $clRequete = null; if (!bReloadFrom($clRequete,'res/QRY_Aulas_Activas_cache_79')) {  $clRequeteSelection_1 = new FMK_SQL_Requete(1); $clClauseSelect_2 = new FMK_SQL_Select(); $clClauseSelect_2->m_eOPTIONSELECT = 1; $clRubrique_3 = new FMK_SQL_Rubrique(); $clRubrique_3->m_sNom = 'AulasID'; $clRubrique_3->m_sAlias = 'AulasID'; $clRubrique_3->m_sNomFichier = 'Aulas'; $clRubrique_3->m_sAliasFichier = 'Aulas'; $clClauseSelect_2->add($clRubrique_3); $clRubrique_4 = new FMK_SQL_Rubrique(); $clRubrique_4->m_sNom = 'Nombre'; $clRubrique_4->m_sAlias = 'Nombre'; $clRubrique_4->m_sNomFichier = 'Aulas'; $clRubrique_4->m_sAliasFichier = 'Aulas'; $clClauseSelect_2->add($clRubrique_4); $clRubrique_5 = new FMK_SQL_Rubrique(); $clRubrique_5->m_sNom = 'Cupo'; $clRubrique_5->m_sAlias = 'Cupo'; $clRubrique_5->m_sNomFichier = 'Aulas'; $clRubrique_5->m_sAliasFichier = 'Aulas'; $clClauseSelect_2->add($clRubrique_5); $clRequeteSelection_1->m_clSelect =& $clClauseSelect_2; $clClauseFrom_6 = new FMK_SQL_From(); $clFromFichier_7 = new FMK_SQL_Fichier(); $clFromFichier_7->m_sNom = 'Aulas'; $clFromFichier_7->m_sAlias = ''; $clClauseFrom_6->add($clFromFichier_7); $clRequeteSelection_1->m_clFrom =& $clClauseFrom_6; $clClauseWhere_8 = null; $clClauseWhere_8 = new FMK_SQL_Where(); $clOpExp_9 = new FMK_SQL_OpExpression(9,'=','Aulas.Activo = 1'); $clRubExpSimple_10 = new FMK_SQL_Rubrique(); $clRubExpSimple_10->m_sNom = 'Aulas.Activo'; $clRubExpSimple_10->m_sAlias = 'Activo'; $clRubExpSimple_10->m_sNomFichier = 'Aulas'; $clRubExpSimple_10->m_sAliasFichier = 'Aulas'; $clRubExpSimple_10->m_nPosDebut = 110; $clRubExpSimple_10->m_nPosFin = 121; $clRubExpSimple_10->m_nPosDebut = 110; $clRubExpSimple_10->m_nPosFin = 121; $clOpExp_9->add($clRubExpSimple_10); $xOP_LIT_11 = new FMK_SQL_Item(); $xOP_LIT_11->m_sNom = 1; $xOP_LIT_11->m_nPosDebut = 125; $xOP_LIT_11->m_nPosFin = 125; $clOpExp_9->add($xOP_LIT_11); $clOpExp_9->m_nPosDebut = 110; $clOpExp_9->m_nPosFin = 125; $clClauseWhere_8->add($clOpExp_9); $clRequeteSelection_1->m_clWhere =& $clClauseWhere_8; $clClauseGroupBy_12 = null; $clRequeteSelection_1->m_clGroupBy =& $clClauseGroupBy_12; $clClauseHaving_13 = null; $clRequeteSelection_1->m_clHaving =& $clClauseHaving_13; $clClauseOrderBy_14 = null; $clClauseOrderBy_14 = new FMK_SQL_OrderBy(); $clRubriqueOrderBy_15 = new FMK_SQL_Rubrique(); $clRubriqueOrderBy_15->m_sNom = 'Nombre'; $clRubriqueOrderBy_15->m_sAlias = 'Nombre'; $clRubriqueOrderBy_15->m_sNomFichier = 'Aulas'; $clRubriqueOrderBy_15->m_sAliasFichier = 'Aulas'; $clRubriqueOrderBy_15->m_tabOptions['nGetNumColonne'] = 1; $clRubriqueOrderBy_15->m_tabOptions['ORDERBY'] = 0; $clClauseOrderBy_14->add($clRubriqueOrderBy_15); $clRequeteSelection_1->m_clOrderBy =& $clClauseOrderBy_14; $clClauseLimit_16 = new FMK_SQL_Limit(); $clClauseLimit_16->m_nType = 0; $clClauseLimit_16->m_nNombreEnregs = -1; $clClauseLimit_16->m_nDepuis = 0; $clRequeteSelection_1->m_clLimit =& $clClauseLimit_16; $clRequete =& $clRequeteSelection_1; $clRequete->m_sNom = 'QRY_Aulas_Activas'; $clRequete->m_sCodeOriginel = 'SELECT  	Aulas.AulasID AS AulasID,	 	Aulas.Nombre AS Nombre,	 	Aulas.Cupo AS Cupo FROM  	Aulas WHERE  	Aulas.Activo = 1 ORDER BY  	Nombre ASC'; $clRequete->term('res/QRY_Aulas_Activas_cache_79'); } //fin du test de reload depuis le cache "
ARBRE_CACHE="res/QRY_Aulas_Activas_cache_79"
[PARAMETRES]
NB=0

[RUBRIQUES]
NB=3
ALIAS0="AulasID"
FICHIER0="Aulas"
RUBRIQUE0="AulasID"
ALIAS1="Nombre"
FICHIER1="Aulas"
RUBRIQUE1="Nombre"
ALIAS2="Cupo"
FICHIER2="Aulas"
RUBRIQUE2="Cupo"

[FICHIERS]
NB=1
FICHIER0="Aulas"

[TRIS]
NB=1
TRI0="Nombre"

SENS0="ASC"
