MS4BI HELP 2019

by MS4script
01-Introduction
Preface & Copyright
Getting started
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
Connect DB Create, delete
Import DataSource Import, Consolidation
Administration Admin, User
05- Sql-Query
Sql
Query Form : BTS,SHOW
Grid option
06- Charts
Forms Show, 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.
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 Special
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
14- Cloud.
Account Open
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 : MS4BI by MS4script 2019 version 1

Chapter 3 : INSTRUCTIONS

KEYWORD : GETCURRENTDIR

Definition

Returns the current directory for the MS4 script that is being run.

Syntax

 		  	
	     GetCurrentDir(string);
 	

Example

 	
TEXT :	  LCurrentDir;
GetCurrentdir(LCurrentDir);
 	
	

See Also

SetCurrentDir(string);..



KEYWORD : GETDIRSYSPATHWWW

Definition

Returns the root directory of the MS4BI server:

driverInstall:\MondaySoftware\MS4BI\Winserver\www

Syntax

 		  	
	     GetDirSysPathWWW(string)
  	
	

Example

 	
CHAR    : ldirApp:128 , lenvSqlstring:128  := "\demo\DESKTOP-BI-EXCELandSTANDARD\DESKTOP-BI-CENTRAL-CUBES\Ms4BI-DemoExcelCube.db";
INTEGER :  X  ;
		 
		BEGIN  
  			GetDirSysPathWWW(lDirApp);
			Concatene  lDirApp,lenvSqlstring into LEnvDemoExcelDB ;
		 	
 			DBexist{Ms4DB}(LEnvDemoExcelDB) return (X) ;
               END
	
	

Remarks




KEYWORD : GETDIRSYSPATHMS4BI

Definition

Returns the MS4BI tool's root directory :

driverInstall:\MondaySoftware\MS4BI\

Syntax

 		  	
	     GetDirSysPathMS4BI(string)
 	
	

Example

 	
    
text  :lDirApp , lenvSqlstring := "\02-DEMO-DESKTOP-BI-EXCELandSTANDARD\99-DATABASE\VersionADO\Ms4BI-DemoExcelCube.db", LEnvDemoExcelDB;
   
		BEGIN  

			GetDirSysPathMS4BI(lDirApp);
			Concatene  lDirApp,lenvSqlstring into LEnvDemoExcelDB ;
               END
	
	

Remarks




KEYWORD : GETDIRSYSPATH

Definition

Returns the root directory for :

driverInstall:\MondaySoftware\

Syntax

 		  	
	     GetDirSysPath(string)
 	
	

Example

 	
GetDirSysPath(LpathDataBaseExcel);
Concatene  LpathDataBaseExcel,"\zInclude\css\StyleReportDesign\standardStyleReport.css" into fileStyleCss;
	
	

Remarks




KEYWORD : #DIRSYSPATH+

Definition

Adds the directory located at :

driverInstall:\MondaySoftware\ to a literal

Syntax

 		  	
	      "#DRIVERSYS+\......DIRECTORY......"
 	
	

Example

 ** Automatically positions in a specified directory  	
SetCurrentDir("#DRIVERSYS+\MondaySoftware\MS4BI\02-DEMO-DESKTOP-BI-EXCELandSTANDARD\10-SECURITE\ExamplesEncrypt");
	
	

Remarks




KEYWORD : #INCLUDESYSPATHWWW+

Definition

Includes an MS4 script located in the

driverInstall:\MondaySoftware\MS4BI\Winserver\www root directory

Syntax

 		  	
	      "#INCLUDESYSPATHWWW+\......DIRECTORY......\ scriptname.ms4"
 	
	

Example


 
#includeSYSpathWWW "\demo\DESKTOP-BI-EXCELandSTANDARD\99-DATABASE\VersionADO\300-CreateDBDemoExcel.ms4"
ConnectDB{Ms4DB}(LEnvDemoExcelDB); FormShow : DrawGrid, title :"2013" use View ("[ms4EmplTotalBusiness2013]") ;

Remarks




KEYWORD : #INCLUDESYSPATHMS4BI+

Definition

Includes an MS4 script located in the

driverInstall:\MondaySoftware\MS4BI\ root directory

Syntax

 		  	
	      "#INCLUDESYSPATHMS4BI+\......REPERTOIRE......\ nom du script.ms4"
 	
	

Example


 
#includeSYSpathMS4BI "\zInclude\includeChart.h"
or MENU MenuId 111 : DrawMs4Script : "#INCLUDESYSPATHMS4BI+\02-DEMO-DESKTOP-BI-EXCELandSTANDARD\90-OTHERS-UI\1300-TableResponsive.ms4",

Remarks




Interested in our project? contact@monday-software.com
The Monday Software team


Copyright 2020 by Monday Software

the official sites :
www.monday-software.com
www.ms4bi.com
demos.ms4bi.com
getms4bi.com
getms4bifree.com
cloud.ms4bi.com
cloud.testing.ms4bi.com
www.ms4script.com

Our purpose : Keep it simple !


written with ms4script
  • MS4BI v.01.0027.01.2020
  • MS4BIRE v.01.0021.10.2019
  • MS4SCRIPT v.01.0027.01.2020
  • help 06/2019

MS4BI in 5 minutes