           BASIC HELP : MS4BI by MS4script   
   2023 version 1.18

Chapter 3 : INSTRUCTIONS

KEYWORD : GETCURRENTDIR

Definition
Returns the current directory for the MS4 script that is being run.

Syntax

  		  	
	     GetCurrentDir(string);

Example

  	
TEXT :	  LCurrentDir;
GetCurrentdir(LCurrentDir);

See Also
SetCurrentDir(string);..

KEYWORD : GETDIRSYSPATHWWW

Definition
Returns the root directory of the MS4BI server:
driverInstall:\MandragorePlanete\MS4BI\Winserver\www

Syntax

  		  	
	     GetDirSysPathWWW(string)

Example

  	
CHAR    : ldirApp:128 , lenvSqlstring:128  := "\demo\DESKTOP-BI-EXCELandSTANDARD\DESKTOP-BI-CENTRAL-CUBES\Ms4BI-DemoExcelCube.db";
INTEGER :  X  ;
		 
		BEGIN  
  			GetDirSysPathWWW(lDirApp);
			Str_Cat  lDirApp,lenvSqlstring into LEnvDemoExcelDB ;
		 	
 			DBexist{Ms4DB}(LEnvDemoExcelDB) return (X) ;
               END

Remarks

KEYWORD : GETDIRSYSPATHMS4BI

Definition
Returns the MS4BI tool s root directory :
driverInstall:\MandragorePlanete\MS4BI\

Syntax

  		  	
	     GetDirSysPathMS4BI(string)

Example

  	
    
text  :lDirApp , lenvSqlstring := "\02-DEMO-DESKTOP-BI-EXCELandSTANDARD\99-DATABASE\VersionADO\Ms4BI-DemoExcelCube.db", LEnvDemoExcelDB;
   
		BEGIN  

			GetDirSysPathMS4BI(lDirApp);
			Str_Cat  lDirApp,lenvSqlstring into LEnvDemoExcelDB ;
               END

Remarks

KEYWORD : GETDIRSYSPATH

Definition
Returns the root directory for :
driverInstall:\MandragorePlanete\

Syntax

  		  	
	     GetDirSysPath(string)

Example

  	
GetDirSysPath(LpathDataBaseExcel);
Str_Cat  LpathDataBaseExcel,"\zInclude\css\StyleReportDesign\standardStyleReport.css" into fileCssStyle;

Remarks

KEYWORD : #DIRSYSPATH+

Definition
Adds the directory located at :
driverInstall:\MandragorePlanete\ to a literal

Syntax

  		  	
	      "#DRIVERSYS+\......DIRECTORY......"

Example

  ** Automatically positions in a specified directory  	
SetCurrentDir("#DRIVERSYS+\MandragorePlanete\MS4BI\02-DEMO-DESKTOP-BI-EXCELandSTANDARD\91-SECURITY\ExamplesEncrypt");

Remarks

KEYWORD : #SYSPATHWWW+

Definition
Includes an MS4 script located in the
driverInstall:\MandragorePlanete\MS4BI\Winserver\www root directory

Syntax

  		  	
	      "#SYSPATHWWW+\......DIRECTORY......\ scriptname.ms4"

Example

 
   #include  "#SYSPATHWWW\demo\DESKTOP-BI-EXCELandSTANDARD\99-DATABASE\VersionADO\300-CreateDBDemoExcel.ms4"  
  DBconnect{Ms4DB}(LEnvDemoExcelDB);
  FormPlus : DrawGrid, title :"2013"   use   View  ("[ms4EmplTotalBusiness2013]")  ;

Remarks

KEYWORD : #SYSPATHMS4BI+

Definition
Includes an MS4 script located in the
driverInstall:\MandragorePlanete\MS4BI\ root directory

Syntax

  		  	
	      "#SYSPATHMS4BI+\......REPERTOIRE......\ scriptname.ms4"

Example

 
   #SYSPATHMS4BI+  "\zInclude\includeChart.h"    
   
  or 
  MENU
MenuId 111  : Ms4Script_Import : "#SYSPATHMS4BI+\02-DEMO-DESKTOP-BI-EXCELandSTANDARD\90-OTHERS-UI\1300-TableResponsive.ms4",

Remarks

KEYWORD : #WWWMS4BISERVER+

Definition

located your db into Web root directory of MS4BI

Syntax

  		  	
	      "#WWWMS4BISERVER+\yourdbname.db"

Example

 
    text NewDb :="#WWWMS4BISERVER+\Myms4bi.db"; 
  ** <Local_server >			
	DBconnect {Ms4DB} (NewDb) ;or DBconnect {Ms4DB} (	"#WWWMS4BISERVER+\yourdbname.db");
    or   DBDelete{MS4DB}(NewDb);

Remarks
Preferably use a local server to define your database with "#WWWMS4BISERVER+\yourdbname"
You can define your database in a directory on your computer.
Problem: when exporting source code to an https server, the location of the database needs to be edited

KEYWORD : #WWWMS4BISERVERBACKUP+

Definition

Backup your db into Web root directory of MS4BI Backup

Syntax

  		  	
	      "#WWWMS4BISERVERBACKUP+\yourdbname.db"

Example

 
    text NewDb :="#WWWMS4BISERVER+\Myms4bi.db"; 
  ** <Local_server >			
	DBBackup{Ms4db}(NewDb) to ("#WWWMS4BISERVERBACKUP+\Myms4bi.db") return (x);
     if(x =1)then display  "Backup Ok" ; else "Backup ko" ;end_if ;

Remarks
Return :
0 Backup error
1 Backup OK

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

The official sites :

Business

Presentation

Code

ms4script.com

Download

download.ms4bi.com

Purchase

purchase.ms4bi.com

Support

support.ms4bi.com

Our purpose : Keep it simple !

written with ms4script

help 01.020.02.2024

MS4BI in 5 minutes

MS4BI Trial Version : Informations :
this message will disappear : Purchase Professional Licence :

https://www.ms4bi.com

MS4BI HELP 2022

Designer

BASIC HELP : MS4BI by MS4script

Chapter 3 : INSTRUCTIONS

KEYWORD : GETCURRENTDIR

Definition

Syntax

Example

See Also

KEYWORD : GETDIRSYSPATHWWW

Definition

driverInstall:\MandragorePlanete\MS4BI\Winserver\www

Syntax

Example

Remarks

KEYWORD : GETDIRSYSPATHMS4BI

Definition

driverInstall:\MandragorePlanete\MS4BI\

Syntax

Example

Remarks

KEYWORD : GETDIRSYSPATH

Definition

driverInstall:\MandragorePlanete\

Syntax

Example

Remarks

KEYWORD : #DIRSYSPATH+

Definition

driverInstall:\MandragorePlanete\ to a literal

Syntax

Example

Remarks

KEYWORD : #SYSPATHWWW+

Definition

driverInstall:\MandragorePlanete\MS4BI\Winserver\www root directory

Syntax

Example

#include "#SYSPATHWWW\demo\DESKTOP-BI-EXCELandSTANDARD\99-DATABASE\VersionADO\300-CreateDBDemoExcel.ms4"

Remarks

KEYWORD : #SYSPATHMS4BI+

Definition

driverInstall:\MandragorePlanete\MS4BI\ root directory

Syntax

Example

#SYSPATHMS4BI+ "\zInclude\includeChart.h"

Remarks

KEYWORD : #WWWMS4BISERVER+

Definition

located your db into Web root directory of MS4BI

Syntax

Example

text NewDb :="#WWWMS4BISERVER+\Myms4bi.db";

Remarks

KEYWORD : #WWWMS4BISERVERBACKUP+

Definition

Backup your db into Web root directory of MS4BI Backup

Syntax

Example

text NewDb :="#WWWMS4BISERVER+\Myms4bi.db";

Remarks

The official sites :

Business

Demo

Help

Cloud

Presentation

Code

Download

Purchase

Support

Copyright 2020 by Mandragore Planete

Our purpose : Keep it simple !

MS4BI in 5 minutes