Ms4_Query: web{driver} 
   (optional)Option : BEGIN   Attributes  END
      (  "string or literal = SQL " + "rest of string or literal = SQL instruction",
 
	  (optional : variables) ,ivalue, Lvalue, fvalue, dvalue,     ) ;


  -  The variables are defined using the following convention:  %i  integer, %l  long ,%f  float ,%d double ,%s char or text

	

  		   
DBconnect{Ado:"xls"}("#DRIVERSYS+:\MandragorePlanete\MANDRAGORE\02-DEMO....\2-QUERIES\EXCEL\..\viewInvoices.xls");
Ms4_Query: web{Ado:"xls"}("SELECT * FROM [viewInvoices$]   " );

OR

 Ms4_Query:  web{Ado:"xls"} 
Option  : 
  BEGIN 
   Style   :$BLue ,
   height  :550,     
   pagesize:100,
   EXPORTEXCEL : yes   , 
   Pageable :yes,
   Resizable :yes, 
   Sortable :yes,
   ViewResult:yes,
   filterable:yes
  END  
 ("SELECT *  FROM [Sheet1$]   " );	

or

 FormPlus : Ms4_Query  {Ado:"xls"} 
	BEGIN
      SetUniCode(True);
         DBconnect{Ado:"xls"}(LcurrentDirExcel);
        Ms4_Query: Web{Ado:"xls"}
         Option  : 
         BEGIN 
              Style :$METRO  
          END 
          ("SELECT * FROM [中国最大の都市のリスト$]     " );
       END ;
	
	

  	
   Visualise Example 1   
 	
   Source Basic Query   	
 
    Source & Copy Basic Query     	
 
 
	

  	 
  Visualise ALL EXAMPLES : Queries      

  Visualise ALL   EXAMPLES    
	
	

  	
   Setting :
	Chart :
	Backgroundcolor : $color_bkMANDRAGORE 
	ToolBarExport  : yes  ;
  
      DBconnect{Ms4DB}(LEnvDemoExcelDB); 
       Ms4_query:web{ms4db}   
        ( " SELECT OrderID ,CustomerID,	EmployeeID,	" + 
           "        OrderDate,	RequiredDate,	ShippedDate "+
           " from   [ms4EmplConsolidationBusiness]  order by EmployeeID desc limit 2 " ) ; 
                   ** TOP 2 employeeid
	

  
BEGIN 
  TEXT  Stable1 := "ms4EmplTotalBusiness2013"; 
  integer IretSql;
   DBconnect{Ms4DB}(LEnvDemoExcelDB);   
   Ms4_Query: Web{ms4db}
   Option  : /* optional */
		BEGIN 
            style :$BLACK ,
		
 		END  
("SELECT  A.lastname as myname, printf('%.02f',b.BUSINESSID2011) as YEAR2011,printf('%.02f',A.BUSINESSID2013 ) AS YEAR2013  "+
" FROM   %s  as A  join  ms4EmplTotalBusiness2011  as B "+
" where  a.lastname = b.lastname", Stable1 ) return IretSql;/* dynamic sql : possible : %s = Stable1 */
  END ;