[REQUETE]
NOM="QRY_Niveles_Activos"
SQL=" SELECT  Niveles.NivelesID AS NivelesID,	 Niveles.Nombre AS Nombre,	 Niveles.Nombre+' '+Niveles.Codigo AS NombreCompleto,	 Niveles.Orden AS Orden  FROM  Niveles  WHERE   Niveles.Activo = 1  ORDER BY  Orden ASC"
ARBRE="/* Génération automatique de l'abre de la requête QRY_Niveles_Activos */ $clRequete = null; if (!bReloadFrom($clRequete,'res/QRY_Niveles_Activos_cache_21')) {  $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 = 'NivelesID'; $clRubrique_3->m_sAlias = 'NivelesID'; $clRubrique_3->m_sNomFichier = 'Niveles'; $clRubrique_3->m_sAliasFichier = 'Niveles'; $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 = 'Niveles'; $clRubrique_4->m_sAliasFichier = 'Niveles'; $clClauseSelect_2->add($clRubrique_4); $clOpExp_6 = new FMK_SQL_OpExpression(0,'+','Niveles.Nombre+\' \'+Niveles.Codigo'); $clOpExp_7 = new FMK_SQL_OpExpression(0,'+','Niveles.Nombre+\' \''); $clRubExpSimple_8 = new FMK_SQL_Rubrique(); $clRubExpSimple_8->m_sNom = 'Niveles.Nombre'; $clRubExpSimple_8->m_sAlias = 'Nombre'; $clRubExpSimple_8->m_sNomFichier = 'Niveles'; $clRubExpSimple_8->m_sAliasFichier = 'Niveles'; $clRubExpSimple_8->m_nPosDebut = 74; $clRubExpSimple_8->m_nPosFin = 87; $clRubExpSimple_8->m_nPosDebut = 74; $clRubExpSimple_8->m_nPosFin = 87; $clOpExp_7->add($clRubExpSimple_8); $xOP_LIT_9 = new FMK_SQL_Item(); $xOP_LIT_9->m_sNom = ' '; $xOP_LIT_9->m_nPosDebut = 89; $xOP_LIT_9->m_nPosFin = 91; $clOpExp_7->add($xOP_LIT_9); $clOpExp_7->m_nPosDebut = 74; $clOpExp_7->m_nPosFin = 91; $clOpExp_6->add($clOpExp_7); $clRubExpSimple_10 = new FMK_SQL_Rubrique(); $clRubExpSimple_10->m_sNom = 'Niveles.Codigo'; $clRubExpSimple_10->m_sAlias = 'Codigo'; $clRubExpSimple_10->m_sNomFichier = 'Niveles'; $clRubExpSimple_10->m_sAliasFichier = 'Niveles'; $clRubExpSimple_10->m_nPosDebut = 93; $clRubExpSimple_10->m_nPosFin = 106; $clRubExpSimple_10->m_nPosDebut = 93; $clRubExpSimple_10->m_nPosFin = 106; $clOpExp_6->add($clRubExpSimple_10); $clOpExp_6->m_nPosDebut = 74; $clOpExp_6->m_nPosFin = 106; $clOpExp_6->m_sAlias = 'NombreCompleto'; $clRubrique_5 =& $clOpExp_6; $clClauseSelect_2->add($clRubrique_5); $clRubrique_11 = new FMK_SQL_Rubrique(); $clRubrique_11->m_sNom = 'Orden'; $clRubrique_11->m_sAlias = 'Orden'; $clRubrique_11->m_sNomFichier = 'Niveles'; $clRubrique_11->m_sAliasFichier = 'Niveles'; $clClauseSelect_2->add($clRubrique_11); $clRequeteSelection_1->m_clSelect =& $clClauseSelect_2; $clClauseFrom_12 = new FMK_SQL_From(); $clFromFichier_13 = new FMK_SQL_Fichier(); $clFromFichier_13->m_sNom = 'Niveles'; $clFromFichier_13->m_sAlias = ''; $clClauseFrom_12->add($clFromFichier_13); $clRequeteSelection_1->m_clFrom =& $clClauseFrom_12; $clClauseWhere_14 = null; $clClauseWhere_14 = new FMK_SQL_Where(); $clOpExp_15 = new FMK_SQL_OpExpression(9,'=','Niveles.Activo = 1'); $clRubExpSimple_16 = new FMK_SQL_Rubrique(); $clRubExpSimple_16->m_sNom = 'Niveles.Activo'; $clRubExpSimple_16->m_sAlias = 'Activo'; $clRubExpSimple_16->m_sNomFichier = 'Niveles'; $clRubExpSimple_16->m_sAliasFichier = 'Niveles'; $clRubExpSimple_16->m_nPosDebut = 180; $clRubExpSimple_16->m_nPosFin = 193; $clRubExpSimple_16->m_nPosDebut = 180; $clRubExpSimple_16->m_nPosFin = 193; $clOpExp_15->add($clRubExpSimple_16); $xOP_LIT_17 = new FMK_SQL_Item(); $xOP_LIT_17->m_sNom = 1; $xOP_LIT_17->m_nPosDebut = 197; $xOP_LIT_17->m_nPosFin = 197; $clOpExp_15->add($xOP_LIT_17); $clOpExp_15->m_nPosDebut = 180; $clOpExp_15->m_nPosFin = 197; $clClauseWhere_14->add($clOpExp_15); $clRequeteSelection_1->m_clWhere =& $clClauseWhere_14; $clClauseGroupBy_18 = null; $clRequeteSelection_1->m_clGroupBy =& $clClauseGroupBy_18; $clClauseHaving_19 = null; $clRequeteSelection_1->m_clHaving =& $clClauseHaving_19; $clClauseOrderBy_20 = null; $clClauseOrderBy_20 = new FMK_SQL_OrderBy(); $clRubriqueOrderBy_21 = new FMK_SQL_Rubrique(); $clRubriqueOrderBy_21->m_sNom = 'Orden'; $clRubriqueOrderBy_21->m_sAlias = 'Orden'; $clRubriqueOrderBy_21->m_sNomFichier = 'Niveles'; $clRubriqueOrderBy_21->m_sAliasFichier = 'Niveles'; $clRubriqueOrderBy_21->m_tabOptions['nGetNumColonne'] = 3; $clRubriqueOrderBy_21->m_tabOptions['ORDERBY'] = 0; $clClauseOrderBy_20->add($clRubriqueOrderBy_21); $clRequeteSelection_1->m_clOrderBy =& $clClauseOrderBy_20; $clClauseLimit_22 = new FMK_SQL_Limit(); $clClauseLimit_22->m_nType = 0; $clClauseLimit_22->m_nNombreEnregs = -1; $clClauseLimit_22->m_nDepuis = 0; $clRequeteSelection_1->m_clLimit =& $clClauseLimit_22; $clRequete =& $clRequeteSelection_1; $clRequete->m_sNom = 'QRY_Niveles_Activos'; $clRequete->m_sCodeOriginel = 'SELECT  	Niveles.NivelesID AS NivelesID,	 	Niveles.Nombre AS Nombre,	 	Niveles.Nombre+\' \'+Niveles.Codigo AS NombreCompleto,	 	Niveles.Orden AS Orden FROM  	Niveles WHERE  	Niveles.Activo = 1 ORDER BY  	Orden ASC'; $clRequete->term('res/QRY_Niveles_Activos_cache_21'); } //fin du test de reload depuis le cache "
ARBRE_CACHE="res/QRY_Niveles_Activos_cache_21"
[PARAMETRES]
NB=0

[RUBRIQUES]
NB=4
ALIAS0="NivelesID"
FICHIER0="Niveles"
RUBRIQUE0="NivelesID"
ALIAS1="Nombre"
FICHIER1="Niveles"
RUBRIQUE1="Nombre"
ALIAS2="NombreCompleto"
FICHIER2="Niveles"
RUBRIQUE2="Nombre+' '+Niveles.Codigo"
ALIAS3="Orden"
FICHIER3="Niveles"
RUBRIQUE3="Orden"

[FICHIERS]
NB=1
FICHIER0="Niveles"

[TRIS]
NB=1
TRI0="Orden"

SENS0="ASC"
