I declare a forms with a block based on a "From clause query".
So in the field "Query data source name" I enter my SQL order :
select ENTREE_BE.code_dom,
ENTREE_BE.num_dem,FAMILMAT.code_fami_mat niv_rupt,
FAMILMAT.lib lib_phase
from ENTREE_BE, MATIERE, FAMILMAT
where ENTREE_BE.code_art_com = MATIERE.nom_mat
and MATIERE.code_fami_mat = FAMILMAT.code_fami_mat
group by FAMILMAT.code_fami_mat, FAMILMAT.lib,ENTREE_BE.code_dom,
ENTREE_BE.num_dem
order by FAMILMAT.code_fami_mat
It works good but in this request I can't enter fields from my forms block.
As soon as I add in the where clause
" and ENTREE.BE.num_dem = :ZIN02W01_B5.NUM_DEM "
the forms gives me an error.
Is someone could help me on this purpose ?
Thanks.
Partager