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 : FORMULA

Definition

Create a complex mathematical formula, returning an integer, long, float or double type value.

Syntax

 		VarName = FORMULA(<(expressions)><(expressions)>...) 	
 	
	

Example

  
float : fvalue dec(2) ;
Double : dvalue dec(2);
long   :   lvalue;
integer:   ivalue;
Display "--------------------------------------------------------- " ;
Display "                     Example complex/scientific FORMULA  " ;
 BEGIN 
  
	Dvalue := Formula(  "(  (((2*30)+50 )^2)- ( (20-6 ) *2 ) ) *1000000 /( (1000/2) *4 )"   ) ;

Dvalue :=  Formula(" Sin(0.25 * PI)^2");
 
Dvalue :=  Formula(" exp(20)");
Dvalue :=  Formula(" ABS(234)");
Dvalue :=  Formula(" Sin(1200*5)");
Dvalue :=  Formula(" 2.5 * ( 3 + 1.1 * Sqrt(25))");

dvalue := Formula(" 3.5^2"); 
 ** VARIABLES !!!!
 ivalue:= 2; Lvalue := 30;fvalue :=1000;
 
 clear dvalue;
  dvalue := 1000000;
		Dvalue := Formula(  "( (((%i*%l)+50 )^2)- ( (20-6 ) *%i ) ) "+
	                    " *%d /( (%f/2) *4)",ivalue,Lvalue,ivalue,dvalue,fvalue    ) ;

         Display "Formula   VARIABLE :  Double value = ", Dvalue;
	

Pre-requisites

Mathematical function with constants that can be arithmetic ABS , EXP ,SIGN,SQRT,LOG,LOG10 trigonometric SIN,COS,TAN,ASIN,ACOS,ATAN probability FACTORIAL
othes E 2.7182818284590452353602874713527
PI 3.1415926535897932384626433832795

Remarks

The variables are defined using the following convention: %i integer, %l long ,%f float ,%d double



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