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 2: DECLARATION STRUCTURE

KEYWORD : none

Definition

Create a script with no program structure (optional)

Syntax

 
	 
			instructions..
	 	
	

Example

 	
       	INTEGER :  i:=105 ;
		TEXT: stext1:= "Monday";
		LONG : i2 :=2000000;
  
		display "  i :",i;
		display " stext1 :",stext1;
		display "  i2:",i2 ;
		enter;
	 	

Pre-requisites

none

Remarks

Not case sensitive



KEYWORD: BEGIN..END

Definition

Create a script with a simple blocked programming structure (optional)

Syntax

 
	       BEGIN
			  instructions.. 
	 	   END ; 
	

Example

 	
       	INTEGER :  i:=105 ;
		TEXT: stext1:= "Monday";
		LONG : i2 :=2000000;
     BEGIN /* display bloc 1 ..*/
		display "  i :",i;
		display " stext1 :",stext1;
		display "  i2:",i2 ;
		enter;
	 END;	
	 	

Pre-requisites

None

Remarks

Not case sensitive



KEYWORD : BEGIN_Main END_Main

Definition

Create a structured MS4SCRIPT script: Call the following structures: global , begin_main , Function, Procedure.. (optional)

Syntax

 
	GLOBAL
	    declare..
	END_GLOBAL
	BEGIN_Main
        instructions..  	
	END_Main
	
	
	
	

Example

 	
    GLOBAL
    
		INTEGER :  i:=105 ;
		TEXT: stext1:= "Monday";
		LONG : i2 :=2000000;
	END_Global

	BEGIN_Main
 
		display "  i :",i;
		display " stext1 :",stext1;
		display "  i2:",i2 ;
		enter;
	END_Main

   
	
	

Pre-requisites

Global .. End_global

Remarks

Not case sensitive



KEYWORD : FUNC(..)

Definition

Create a structured MS4SCRIPT script. Call the following structures: global, begin_main, Procedure.. (optional)

Syntax

 
	GLOBAL
	    declare..
	END_GLOBAL
	BEGIN_Main
        instructions..  
          function-name  return (var1,var2,varn..);		
	END_Main
	Func Name(var1,var2.. or void)
 
	begin_function
		local
			declare..
		end_local
			instructions..  
	 
	end_function
	
	
	

Example

 	
GLOBAL
    
 	INTEGER :  i:=105 ;
	TEXT: stext1;
	LONG : i2 ;
END_Global

BEGIN_Main

	RanDomInt(void ) return  (i,stext1,i2);
  	display " ";
	display " return i :",i;
	display " return stext1 :",stext1;
	display " return i2:",i2 ;
	enter;
END_Main
 

func  RanDomInt(void)
begin_function
local
integer : y   :=99   ;
long : y2      :=4310212  ;
TEXT : localText :="Monday" ;
end_local
  display "before Local y :",y ;
    y := Random();

    display "After Local y : ",y ;
    display "After Local localText : ",localText;
return y ,localText,y2; 
end_function

   
	
	

Pre-requisites

Global .. End_global begin_main..end_main or perform ..exit

Remarks

Not case sensitive. The Return instruction can return up to 99 variables of all types (char,integer, long..)



KEYWORD : PROC (..)

Definition

Create a structured MS4SCRIPT script. Call the following structures: global , begin_main , Function, Procedure.. (optional)

Syntax

 
	GLOBAL
	    declare..
	END_GLOBAL
	BEGIN_Main
        instructions..  
          proc-name  return (var1,var2,varn..);		
	END_Main
	PROC Name(var1,var2.. or void)
 	begin_procedure
		local
			declare..
		end_local
			instructions..  
 	end_procedure
	
	
	

Example

 	
 GLOBAL 
 	CHAR : Msgframe1:255,Msgframe2:255, Gnumber:6; 
	INTEGER :X,I,ystop;
    INTEGER : Inverse := 1,Noinverse :=0 ;
End_Global

Begin_Main
	Screen_PRESENTATION(Void) ;
End_Main

PROC Screen_PRESENTATION(Void)
Begin_Procedure
	LOCAL
		CHAR  : PostalAddress:512 := " $n  $n   
        	$n Office 9
			$n 70 Upper Richmond Road 
        	$n SW15 2RP London UK  ";
		INTEGER : Exit_TRANS1 :=0; 
		LONG : Color1 ;
  
	End_Local
.. instructions..
End_Procedure
   
	
	

Pre-requisites

Global .. End_global begin_main..end_main or perform ..exit

Remarks

Not case-sensitive RETURN instruction not permitted
Returns nothing


KEYWORD : PERFORM ....EXIT ;

Definition

Create a structured MS4SCRIPT script: Call the following Perform...Exit : Function, Procedure..

Syntax

 
	    instructions.. 
       PERFORM func or PRoc(var1,var2.. or void)..		
		instructions.. 
			EXIT ;
			
	PROC or FUNC Name(var1,var2.. or void)
 	begin_...
		local
			declare..
		end_local
			instructions..  
 	end_...
	
	
	

Example

 	
    Perform InsertTable(void);
	Exit ;
	
	proc InsertTable(void)
	begin_procedure	
	** For example !
  
		ConnectDB{Ms4DB}(LEnvDemoExcelDB); 
		TableExist{ms4db}("TABEXAMPLE") Return  ( msgsql) ; /* 2 return codes : TRUE or FALSE */
	 		if ( msgsql = TRUE) then Ms4_sql{ms4db} ( " Drop  Table  [TABEXAMPLE] "); end_if ;
	
		Ms4_SQL{ms4DB}("CREATE TABLE [TABEXAMPLE] "+ 
		"(      [INDEXID] TEXT,"+ 
		"       [LONGSTRING] char(1024),"+ 
		"       PRIMARY KEY (`INDEXID`) )");  
 
		Ms4_SQL{ms4DB}("INSERT INTO TABEXAMPLE VALUES('INDEX0','%s')",GeoMapRef[0].stringval);
		Ms4_SQL{ms4DB}("INSERT INTO TABEXAMPLE VALUES('INDEX1','%s')",GeoMapRef[1].stringval);
		Ms4_SQL{ms4DB}("INSERT INTO TABEXAMPLE VALUES('INDEX2','%s')",GeoMapRef[2].stringval);
	  ...
	 end_procedure 
   
	
	

Pre-requisites

none

Remarks

Not case sensitive



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


Copyright 2019 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.00.0005.02.2019
  • MS4BIRE v.00.0005.02.2019
  • MS4SCRIPT v.00.0005.02.2019
  • help 02/2019

MS4BI in 5 minutes