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 TYPES

KEYWORD : SCALAR

Definition

    Scalar types:
  • INTEGER
  • LONG
  • FLOAT (number with floating decimal)
  • DOUBLE (number with floating decimal)
  • CHAR (number of characters)
  • TEXT (number of characters, max 255)
  • CONSTANT_STRING (CONSTANT string : number of characters, max 255)
  • CONSTANT_NUM (CONSTANT numeric : type long)
  • DEFINE (DEFINE = CONSTANT numeric : type long)

Syntax

 
		INTEGER : VarName ;(optional-assignment  := XXXXX) 
		LONG 	: VarName ;(optional-assignment  := XXXXX) 
		FLOAT 	: VarName DEC (X) ; (number of decimals) (optional-assignment  := XXXXX or XXXX.XX)
		DOUBLE 	: VarName DEC (X) ;(number of decimals) (optional-assignment  := XXXXXX or XXXXX.XXXXX)

		CHAR 	: VarName :XXX  ;(number of characters) (optional-assignment  := "zzzzzzz")
		TEXT	: VarName  (optional-assignment , max 255 := "zzzzzz")
		CONSTANT_STRING :   VarName "literal max 255" ;
		CONSTANT_NUM :   VarName value ;
		DEFINE       :   VarName value ;
	

Example

 

INTEGER :  X ,I ;
LONG    : Wnt ;
FLOAT   : Y Dec(2),X1 Dec(3):=123.857;
DOUBLE  : Dval Dec(5) := 1234567890123.12345;
CHAR    : Zone1:150 :="Monday " ;
TEXT    : LabelMsg:= "   Simple Calculation .......";

CONSTANT_STRING :  $Bts_btn_default "  type='button' class='btn btn-default ";
CONSTANT_NUM    :  cVal1 20, cVal2  99;

define WS_OVERLAPPED       0x00000000
define WS_POPUP            0x80000000
define WS_CHILD            0x40000000
define WS_MINIMIZE         0x20000000      
 
	

Pre-requisites

Remarks

. Declarations for ALPHANUMERIC scalar: 40 characters max. Cannot contain the following special characters : * + - / ? __ [ ] ( ) { } & | ; , \ " => <= != := : > < = Example : TEXT : LABELMSG;
Example of acceptable or unacceptable FLOAT or DOUBLE values
a = 1.234; OK
b = 1.2e3; NOT OK
c = 7E-10; NOT OK
min/max values :
integer -32 768 to 32 767
long -2 147 483 648 to 2 147 483 647
float 3.4E +/- 38 (7 figures)
double 1.7E +/- 308 (15 figures)
char 0 to 255
For num or string or Define constants: values cannot be changed after declaration.



KEYWORD : ARRAYS

Definition

Simple array with 1 dimension and n occurrences

Syntax

 
 	ARRAYS : Array Name OCCURS XXXX { scalar } 
	 
	 

Example

 
  Arrays : Department OCCURS 10 { INTEGER Number ; CHAR Name :25 ; }
  
  BEGIN
   integer i :=2 ;
   Department[i].Number:= 99 ;
	 
    Display " Department[2].Number :", Department[2].Number;
  END ;
   

Pre-requisites

Remarks

NUMBER OF OCCURRENCES <999999 Advice: Create a temporary table: MS4_SQL{ ..} "CREATE VIEW TEMP name..." + SELECT..



KEYWORD : STRUCT

Definition

Data structure

Syntax

 
 	STRUCT : NameStruct { scalar, table , struct..}
	 
	 

Example

 
	STRUCT : Week {INTEGER Monday,Tuesday, Sunday;}
	STRUCT : ST_INFO 
			{
			
			LONG Postcode  ; 
	  		CHAR Town:40  ;
			INTEGER zint  ;
			CHAR Reference:80  ;
			TEXT LabelTxt;
			FLOAT Ca Dec(2) ;
			DOUBLE Catotal Dec(6) ;
			FLOAT Arrays : BusinessValue dec(2) Occurs 20 ;
			STRUCT:Week;
	  		}
 
  ST_INFO Year2017 ; ** duplicate st_info
  integer i:=2;
 
  ST_INFO.town := "London";
  Year2017.town := "New York";
  Week.Monday := 24; 
  ST_INFO.Week.Monday  := 155;
  ST_INFO.ca := 12345.99;
    ST_INFO.BusinessValue[12] := 8888888.99; 
   

Pre-requisites

SCALAR AND/OR TABLE AND/OR STRUCT

Remark

None

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