Data Ortogonale Projection
Visual Dorp Filter  V.6.1 - Wizard

To speed up the work on creating the forms with vdf objects, Wizard has been developed. In further section, an example is presented of sql command creating and Vdf objects creating, as well as Wizard using.
  1. Select new .dbc
  2. Mover .dbc
  3. Activate vdf project
  4. Select1 tables
  5. Select2 tables       
        
  6.           SELECT  ;
  7.                        [ALL | DISTINCT] [TOP nExpr [PERCENT]]    ;
  8.                             Alias.Select_Item          AS        Column_Name    ,  ;
                                Expr                                AS        Column_Name     ;                    
  9.                 FROM  [FORCE]  ;
  10.                          DataBaseName!Table  ...   ;
  11.                          [ [INNER | LEFT [OUTER] | RIGHT [OUTER] | FULL [OUTER] JOIN   ;
  12.                 ON JoinCondition ...     ; 
  13.                  WHERE ;
                              cxWhereDynamic
                                      [  cxWherePrim1 + cxWhereCond1 + cxWhereSpec1 + cxWhereExt1  +  cxWhereAdv1 ]  + ;
                             cxCommDynamic 
                                      [ cxCommPrim + cxCommCond  + cxCommSpec  + cxCommExt    + cxCommAdv  ]  ;
  14.                  GROUP BY GroupColumn , GroupColumn ...   ;
  15.                  HAVING FilterCondition    ;
  16.  UNION  [ALL]    ;
  17.           SELECT ;
  18.                             Alias.Select_Item          AS       Column_Name   ,  ;
                               Expr                                AS        Column_Name       ;                      
  19.                FROM  [FORCE]  ; 
  20.                          DataBaseName!Table  ...  ;
  21.                          [ [INNER | LEFT [OUTER] | RIGHT [OUTER] | FULL [OUTER] JOIN    
  22.               ON JoinCondition ... ;
  23.               WHERE ;
                            cxWhereDynamic
                                   [  cxWherePrim2 +  cxWhereCond2 +  cxWhereSpec2 +  cxWhereExt2   +  cxWhereAdv2  ]  + ;
                            cxCommDynamic 
                                   [ cxCommPrim + cxCommCond  + cxCommSpec  + cxCommExt    + cxCommAdv  ]  ;
  24.             GROUP BY GroupColumn , GroupColumn ...   ;
  25.             HAVING FilterCondition   ; 
  26.  ORDER BY Order_Item [ASC | DESC] [, Order_Item [ASC | DESC] ...  ;
  27.   INTO  Destination
     

 

  1. Appendix A  
  2.         Vdf wizard - all forms
  3.         Select1 - main page
  4.         Select1 - Dynamic where condition - main page
  5.         Select2 - main page
  6.         Select2 - Dynamic where condition - main page