Hey,
I have the following sql statement to create a view:
CREATE SQL VIEW "vreGlGen" ;
AS SELECT glaccnt.accnt_no, glaccnt.accnt_type,;
gltrans.ident, ;
gltrans.acc_per, gltrans.acc_year,;
gltrans.descr AS trn_desc,;
gltransd.gltrans_id, gltransd.glaccnt_id,;
gltransd.mnt_db, gltransd.mnt_cr ;
FROM glaccnt;
LEFT OUTER JOIN gltransd ;
ON gltransd.glaccnt_id = glaccnt.ident;
LEFT OUTER JOIN gltrans ;
ON gltrans.ident = gltransd.gltrans_id AND;
gltrans.acc_year = INT(?p_year);
ORDER BY glaccnt.accnt_no, ;
gltrans.acc_per, gltransd.gltrans_id
Pretty strange: when I run this, it asks me immediately for the p_year variable, not only when I want to open the view!??
Any ideas?
Thanks
Eric