General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Creating the definition of the view is the same thing as opening the view. You could define a dummy P_Year value before creating the view and issue a Refresh() when you want to use it.
HTH
>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!??
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only