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..
Char/Text functions Char or Text..()
Get + Include functions Get, Include..
String functions String# (hashtag)
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 : CALL:MS4SCRIPT

Definition

Calls an MS4 Script

Syntax

  	 
	 CALL:ms4Script( MS4_script_name);
	
	
	

Example

  		 
        CALL:ms4Script("Ms4wait2");
	
DBconnect{Ado:"xls"}( LSheetExcel);
FormPlus : Ms4_Query {Ado:"xls"} (" SELECT OrderID ,CustomerID,	EmployeeID,	OrderDate,ShipVia"  +
				" FROM  [tableOrders$] order by EmployeeID , OrderID");
 	
	

Call 1 : Output

Prerequisites

All of the scripts must be located in the MS4BI system directory :
driver:\MandragorePlanete\MS4BI\zInclude\Call

Remarks

No parameters or arguments. These are handled in the script that is called.



KEYWORD : CALL:FUNCTION

Definition

Calls a function within an MS4 script, passing an argument to the function via exporting

Syntax

  	 
	 CALL:FUNCTION( MS4_script_name)
	  EXPORTING : ARGUMENT1
	  EXPORTING : ARGUMENT2 ...
	
	

Example

  		 
 CHAR  :ldirApp:128, lenvSqlstring:120 := "\02-DEMO-DESKTOP-BI-EXCELandSTANDARD\99-DATABASE\VersionADO\Ms4BI-DemoExcelCube.db", LEnvDemoExcelDB:256 ;
  	 
		BEGIN ** DB environment
		** retrieve MS4 application directory
  			GetDirSysPathMS4BI(lDirApp);
			Concatene  lDirApp,lenvSqlstring into LEnvDemoExcelDB ;
		 	
 			DBexist{Ms4DB}(LEnvDemoExcelDB) return (X) ;
		/*   return codes */
		** x = 1 : Ok , x = 0 Not ok */
		 if (x  void) then
                  Display "DB not found ", LEnvDemoExcelDB;
					enter;		
					Exit;
          End_if ;
	         END;
             BEGIN ** Call function
                call : function ("LoadDbWin")
                       exporting : LEnvDemoExcelDB
                       exporting : "DBDemoExcel";
             END;	
Source & Copy ms4script/Call input

Prerequisites

All of the scripts must be located in the MS4BI system directory :
driver:\MandragorePlanete\MS4BI\zInclude\Call\function

Remarks

Arguments are handled by the script that is being called.
See (without fail) GETINPUTARGUMENT..



KEYWORD : GETINPUTARGUMENT

Definition

Handles input variables for the function that is being called

Syntax

  	 
	        integer := GETINPUTARGUMENT(number, varName (string))
	
	

Return Values

    1 (TRUE) if the Number/varName is not empty and the string is successful, else 0 (FALSE).

Example

  		 
 CHAR  :lObject:128,  LEnvDB:512 ;
 
 
x:=GetInputArgument(1:LEnvDB); 
if( x != TRUE)
then  
 MsgBox : Title "    LOAD DB  :        "
 Message : " NOT FOUND : NO ARGUMENT..exit !" Column 10
 Button : Mb_OK
 Icon : Mb_IconExclamation ;
 Exit;
end_if ;

Call 2 : Output

Source & Copy ms4script/Call output

Prerequisites

All of the scripts must be located in the MS4BI system directory :
driver:\MandragorePlanete\MS4BI\zInclude\Call\function

Remarks

Declare argument variables (CHAR,TEXT..) Returns the variables content in the same order as CALL/EXPORTING 1, EXPORTING 2

See Also

float , double, integer : Str_num ..

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