           BASIC HELP : MANDRAGORE by MS4script   
   2026 version 1.10

Chapter 5 : SQL and QUERIES

KEYWORD : DRAWGRID

Definition
Creates a WEB grid to interrogate an MS4 DB database

Syntax

   	
	  FormXXX   : DrawGrid, 
	   (optional)Option : BEGIN   Attributes  END
	 title : string or literal  
 	  use   View or Table  ("['your MANDRAGORE DB tablename']")   ;

-Option : FormPlus (ONLY)
BEGIN
style :
$MOONLIGHT or $BLACK or $WHITE or $BLUE or $METRO or $SILVER ,
height : xxx (numeric) ,
EXPORTEXCEL : yes or no ,
pagesize : xx (numeric),
popEdit : yes or no ,
ColumMenu : yes or no ,
Pageable : yes or no ,
Resizable : yes or no ,
Sortable : yes or no ,
ExpandFirst : yes or no ,
filterable : yes or no
END
NB :
yes=1
no =0

Example 1

  		   
  DBconnect{Ms4DB}(LEnvDemoExcelDB); 
   
  FormPlus : DrawGrid 
  Option  : 
BEGIN 
    Style     :$METRO ,
    height    :450,  
    pagesize  :20,
    ColumMenu :yes,
    Pageable  :yes,
    Resizable :yes,
    Sortable  :yes,
    ViewResult:yes,
    filterable:yes
END  
title :"-t01-=014     CHART GRID : BUSINESS EMPLOYEE 2011 Dollars and PRODUCTS   " use   View  ("[ms4EmplTotalBusiness2011]")  ;

MANDRAGORE HELP 2026

Designer

BASIC HELP : MANDRAGORE by MS4script

Chapter 5 : SQL and QUERIES

KEYWORD : DRAWGRID

Definition

Syntax

Example 1

Grid and View/Table