Mandragore Workspce®

MANDRAGORE HELP 2026

by MS4script
01-Introduction
Preface & Copyright
Getting started
Informations + Cmd/param Server
Demos Simple
02- Declarations
Structure
Type
03- Instructions
Conditions if,do,while..
String functions Str..()
Get + Include functions Get, Include..
Date-Time Day, Time, Year.
Display
Call
Formulas Complex
04- Database
Connector Ado, Odbc, Dsn, SAP, Ms4
DB Connect Create, delete
Import DataSource Import, Consolidation
Administration Admin, User
05- Sql-Query
Sql
Query Form : BTS,PLUS
Grid option
06- Charts
Forms Plus, Win, Image, Excel, Morris...
Pie Std, Donut, 3D...
Bar Std, Stack, Line, Area, Plot
Radar
QrCode, Gauge
Step, Stock...
,Google,Leaflet... GeoMap
,Gantt,Timeline,Org.
DrawWindow [web]
07- Dashboard
Form tab, no tab
Responsive UI
08- Report
Report Hierarchy
Report Design
09- Filters
Dialogue + Call
10- Menus
Menu Design
Menu Frameset
Menu Custom
11-UI : Responsive
Tables Responsive,Frame,position
List Group
Text
Panel Header, body, Footer
Button Button, Progress Bar
Icon & Button
Collapse Group, Panel
Notifications
12- Encryption
Encrypt
Decrypt
13- Windows
Dialogue
Picture, Frame, Button..
MsgBox
Grid

Designer

00-OverView
01-Transaction
02-Setting
05-Import
10-Formula
15-Report-Part1
16-Report-Part2
20-Query-Part1
21-Query-Part2
25-Report-Query-Style
30-QrCodeImage
31-Windows
32-Frame
40-TabStrip
50-Collapse
60-BeginForm
63-Input-SubmitBox
70-Input-Select
71-Input-Insert
72-Input-Update
73-Input-Delete
75-Input-Query
77-ListComBo
81-Button-Link
82-Button-DataList
86-Sticky-Label
91-Insert-PhpJsHtml
92-Insert-MS4script
15- Css, html, Php, js.
Insert Native language Begin_sw..End_Sw
16-Install + tools.
Installation & Configuration This Menu
Generate Native... Php, Html, js..
Code Generator Ms4 Script
MarkDown Ms4 Script
Source Code Menu Help This Menu
written with ms4script
      

BASIC HELP : MANDRAGORE by MS4script

2026 version 1.10

Chapter 6 : CHARTS

KEYWORD : FormPlus : DRAWBAR

Definition

Based on the FormPlus graphics library, displays VERTICAL, HORIZONTAL, STACKED, LINE or AREA bar charts.

Syntax

  	
	Simple :
	
	 FormPlus :	DrawBAR  ,  title : string/literal ,  
	  TYPE : integer, FORMAT: string/literal  use View  ("Table Name or $MS4VIEWDBTMP ");
	  
	or 
	
	FormPlus : optional theme : string/literal     
	DrawBAR , optional height : integer, 	width :integer , 
	title :string/literal ,  
      TYPE : integer, FORMAT: string/literal  use View  ("Table Name or $MS4VIEWDBTMP ");
	
	

Example 1

  		   
#include "#SYSPATHMANDRAGORE+\zInclude\includeChart.h"  
 
 DBconnect{Ms4DB}(LEnvDemoExcelDB); 
 FormPlus : DrawBAR, title : "  Business 2012 by  EMPLOYEE "  , TYPE : $COLUMN , FORMAT :"$" 
                        use View   ("[ms4EmplTotalBusiness2012]")  ;

 FormPlus : theme : "blueopal"    DrawBAR , height : "430",  width :"730", title :"" ,  
  TYPE : $STANDARD, FORMAT: "pers"  use View  ("[ms4TotalPopulByProvince]"); 
	

Example 2 : $MS4DBTMP : NB: This example can be applied to any and all chart types

  		   
#include  "#SYSPATHMANDRAGORE+\zInclude\includeChart.h"
text :   tabname :="ms4EmplTotalBusiness2011"  ,varname := "%a%"; 
 
DBconnect{ms4DB}(LEnvDemoExcelDB); 
Ms4_query{ms4db}  option : into  $MS4DBTMP 
  (" SELECT  *    from  [%s]   as a  where a.LASTNAME LIKE '%s' ",tabname,varname) ;

  DBconnect{Ms4DB}($MS4DBTMP);
	 FormPlus  :	DrawBAR , title :" Business 2011 by  EMPLOYEE " ,  
	 TYPE :  $COLUMN,  FORMAT: "$"  use View ($MS4VIEWDBTMP)   ;
 	

DrawBAR, Business 2012 by EMPLOYEE