hello,
on this grid i have to see only the fields with reference 1 and hide the 0
i’m newbies and i learn every day, but i don’t know how hide the fields with ref 0
any explonation from expert pls
I think in Clause WHERE i can set the condiiton SUITCOURS = 1
thank for quick reply,
i think i can’t referr in clause where,
suit_cours refer to a function and the condition is the first line,
suit_cours is not on my query
my query"
SELECT
id_service_prof,
professeur,
numen_prof,
discipline,
code_disc,
sous_discipline,
classe,
code_classe,
id_groupement_discipline_definition,
service_classe,
groupe_classe,
coefficient,
millesime,
validite
FROM
services_prof
where code_classe=‘1C1’"
and conditionnal function is
{suit_cours}=eleve_suit_cours_service_prof({id_eleve},{id_service_prof});
when i run my grid or i set condition on > 0 and i see all fields with 1 but i see too the fields “with” no number
i would hide de no number
sorry for my poor english
Ok thanks, i’ve made a view, and all is ok now