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

KEYWORD : CALL:MS4SCRIPT

Definition

Calls an MS4 Script

Syntax

 	 
	 CALL:ms4Script( MS4_script_name);
	
	
	

Example

 		 
        CALL:ms4Script("Ms4wait2");
	
ConnectDB{Ado:"xls"}( LSheetExcel);
FormShow : 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:\MondaySoftware\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;	

Prerequisites

All of the scripts must be located in the MS4BI system directory :
driver:\MondaySoftware\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

Prerequisites

All of the scripts must be located in the MS4BI system directory :
driver:\MondaySoftware\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 : ConverString ..

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