MS4BIĀ®

MS4BI HELP 2022

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 : MS4BI by MS4script

2022 version 1.10

Chapter 3 : INSTRUCTION

KEYWORD : DISPLAY

Definition

Displays text or messages on screen.

Syntax

  		   	
			DISPLAY LITERAL;
		or  DISPLAY varName
	    or  DISPLAY varName or literal, varName or literal.. COLUMN (optional) column_num, 
					varName or literal, COLUMN (optional) column_num
	
			
	

Example

  
   Display "------------------------------------------------------------------------- " ;
   Display "     Example display ....                                                  " ;
   Display "------------------------------------------------------------------------- " ;
   Display "   to continue,  Click here                  ";

 enter;
 Exit;
		 
	
	

Display 1 : Output

Remarks

varName can be a string, integer, float, long or double



KEYWORD : SETCOLORTEXT

Definition

Changes text & background colours.

Syntax

  		   	
				SetColorText(Hwdisplay:text colour , background colour);		
	
	
	

Example

  	 #include  "#SYSPATHMS4BI+\zInclude\IncludeDisplay.h"
INTEGER : Exit_TRANS1 ,X := 99;

CHAR : Mot1:10 := "EU" , Mot2:10 := "RE",Mot3:10 := "KA" , Word:128 ;

BEGIN
	SetColorText (Hwdisplay:yellow,black) ; 		
	Display "------------------------------------------------------------------------- " ;
	Display "     Example de CORLORTEXT ....          " ;
	Display "------------------------------------------------------------------------- " ;
	BEGIN
		SetColorText (Hwdisplay:Blue,Red) ; 
		Display "   mot1  : " , Mot1 Column 20,
		"mot2  : " , Mot2 Column 45 ,
		"mot3  : " ,Mot3 Column 60;
		Word := "";
	END  ;
	BEGIN
		SetColorText (Hwdisplay:Blue,White) ; 
		Display "WORD.......: before  $concatene ",Word Column 40;
		
		concatene  Mot1,"->",Mot2,"<-",Mot3,"...." into Word ;
		concatene  "" into Word;
		
		SetColorText(Hwdisplay:green,black) ; 
		Display "WORD.......: after $concatene ",Word Column 40;
		Word := "string example";
		Display "WORD.......:  ",Word Column 40;
	END  ;
END  ;
Display "   to continue,  Click here                  ";
enter;
Exit;
		 
	
	

Display 2 : Output

Prerequisite

#include "#SYSPATHMS4BI+\zInclude\IncludeDisplay.h" : mandatory, contains all the colours

Remarks

Hwdisplay : identifier for the main window on the display
Keyword : DEFAULT ; text colour
Keyword : NO_BACKGROUND ; no background colour



KEY WORD : SKIPLINE

Definition

Line break on the display.

Syntax

  		   	
					SkipLine Line_number;		
	
	
	

Example

  	#include  "#SYSPATHMS4BI+\zInclude\IncludeDisplay.h"
	INTEGER : Exit_TRANS1 ,X := 99;

CHAR : Mot1:10 := "EU" , Mot2:10 := "RE",Mot3:10 := "KA" , Word:128 ;

BEGIN
	Setdisplaypos(1, 10,550,450);
	SetColorText(Hwdisplay:Green,black);
	Display "------------------------------------------------------------------------- " ;
	
	Display "     Example de  SetdisplayPos          " ;
	
	Display "------------------------------------------------------------------------- " ;
	BEGIN
	 		Display "   mot1  : " , Mot1 Column 20,
		"mot2  : " , Mot2 Column 45 ,
		"mot3  : " ,Mot3 Column 60;
		clear Word  ;
	END  ;
	BEGIN
		SetColorText(Hwdisplay:red,NO_BACKGROUND) ;
		Display "WORD.......: before  Concatene ",Word Column 40;
		
		concatene  Mot1,"->",Mot2,"<-",Mot3,"...." inTo Word ;
		concatene  "" into Word;
		
		SetColorText(Hwdisplay:red,yellow);
		Display "WORD.......: after  concatene ",Word Column 40;
		SetColorText(Hwdisplay:Default,green);
		 SkipLine 2; 
	END  ;
END  ;
 Display "   to continue,  Click here                  ";
enter;
 Exit;
 
		 
	
	

Remarks




KEYWORD : SETDISPLAYPOS

Definition

Changes the horizontal and vertical positions, and the height and width of the screen.

Syntax

  		   	
			SetDisplayPos( integer X,integer Y,integer nWidth,integer nHeight);
	      

	
	

Example

  	 	     
CHAR : Mot1:10 := "EU" , Mot2:10 := "RE",Mot3:10 := "KA" , Word:128 ;

BEGIN
	Setdisplaypos(1, 10,550,450); 
	SetColorText(Hwdisplay:Green,black);
	Display "------------------------------------------------------------------------- " ;
	
	Display "     Example de  SetdisplayPos          " ;
	
	Display "------------------------------------------------------------------------- " ;
	BEGIN
	 		Display "   mot1  : " , Mot1 Column 20,
		"mot2  : " , Mot2 Column 45 ,
		"mot3  : " ,Mot3 Column 60;
		clear Word  ;
	END  ;
	BEGIN
		SetColorText(Hwdisplay:red,NO_BACKGROUND) ;
		Display "WORD.......: before  Concatene ",Word Column 40;
		
		concatene  Mot1,"->",Mot2,"<-",Mot3,"...." inTo Word ;
		concatene  "" into Word;
		
		SetColorText(Hwdisplay:red,yellow);
		Display "WORD.......: after  concatene ",Word Column 40;
		SetColorText(Hwdisplay:Default,green);
		 SkipLine 2; 
	END  ;
END  ;
 Display "   to continue,  Click here                  ";
enter;
 Exit;
	

Display 3 : Output

Remarks

Interested in joining us? contact@mgplanete.com
The Mg Planete team


Copyright 2022 by Mandragore Planete

the official sites :
mgplanete.com
getms4bi.com
demos.ms4bi.com
help.ms4bi.com
ms4script.com

Download

official site :
getms4bi.com

Our purpose : Keep it simple !


written with ms4script
  • help 01.010.2022.8

MS4BI in 5 minutes