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

2023 version 1.18

Chapter 2 : DECLARATION TYPES

KEYWORD : SCALAR

Definition

    Scalar types:
  • INTEGER
  • LONG
  • FLOAT (number with floating decimal)
  • DOUBLE (number with floating decimal)
  • REAL (number with floating decimal)
  • CHAR (number of characters)
  • TEXT (number of characters, max 255)
  • STRING (automatically manages the memory allocated to store strings.)
  • CONSTANT_STRING (CONSTANT string : number of characters, max 255)
  • CONSTANT_NUM (CONSTANT numeric : type long)
  • DEFINE (DEFINE = CONSTANT numeric : type long)

Syntax

  
		INTEGER : VarName ;(optional-assignment  := XXXXX) 
		LONG 	: VarName ;(optional-assignment  := XXXXX) 
		FLOAT 	: VarName DEC (X) ; (number of decimals) (optional-assignment  := XXXXX or XXXX.XX)
		DOUBLE 	: VarName DEC (X) ;(number of decimals) (optional-assignment  := XXXXXX or XXXXX.XXXXX)
		REAL 	: VarName DEC (X) ;(number of decimals) (optional-assignment  := XXXXXX or XXXXX.XXXXX)

		CHAR 	: VarName :XXX  ;(number of characters) (optional-assignment  := "zzzzzzz")
		TEXT	: VarName  (optional-assignment , max 255 := "zzzzzz");
		STRING : Varstring1,Varstring2...; 
		CONSTANT_STRING :   VarName "literal max 255" ;
		CONSTANT_NUM :   VarName value ;
		DEFINE       :   VarName value ;
		
	

Example

  

INTEGER :  X ,I ;
LONG    : Wnt ;
FLOAT   : Y Dec(2),X1 Dec(3):=123.857;
DOUBLE  : Dval Dec(5) := 1234567890123.12345;
CHAR    : Zone1:150 :="MgPlanete " ;
TEXT    : LabelMsg:= "   Simple Calculation .......";
STRING  : strstring1;
CONSTANT_STRING :  $Bts_btn_default "  type='button' class='btn btn-default ";
CONSTANT_NUM    :  cVal1 20, cVal2  99;

define WS_OVERLAPPED       0x00000000
define WS_POPUP            0x80000000
define WS_CHILD            0x40000000
define WS_MINIMIZE         0x20000000      
 
	

Pre-requisites

Remarks

. Declarations for ALPHANUMERIC scalar: 40 characters max. Cannot contain the following Custom characters : * + - / ? __ [ ] ( ) { } & | ; , \ " => <= != := : > < = Example : TEXT : LABELMSG;
Example of acceptable or unacceptable FLOAT or DOUBLE values
a = 1.234; OK
b = 1.2e3; NOT OK
c = 7E-10; NOT OK
min/max values :
integer -32 768 to 32 767
long -2 147 483 648 to 2 147 483 647
float 3.4E +/- 38 (7 figures)
double 1.7E +/- 308 (15 figures)
char 0 to 255
For num or string or Define constants: values cannot be changed after declaration.

DATA STRUCTURE

Definition

  • STRUCT
  • ARRAY
  • TABLEBTREE
  • TABLE



  • KEYWORD : STRUCT

    Definition

    Data structure

    Syntax

      
     	STRUCT : NameStruct { scalar, table , struct..};
    	 
    	 
    

    Example

      
    	STRUCT : Week {INTEGER MgPlanete,Tuesday, Sunday;}
    	STRUCT : ST_INFO 
    			{
    			
    			LONG Postcode  ; 
    	  		CHAR Town:40  ;
    			INTEGER zint  ;
    			CHAR Reference:80  ;
    			TEXT LabelTxt;
    			FLOAT Ca Dec(2) ;
    			DOUBLE Catotal Dec(6) ;
    			STRING Reference;
    			FLOAT Array : BusinessValue dec(2) Occurs 20 ;
    			STRUCT:Week;
    	  		};
     
      ST_INFO Year2017 ; ** duplicate st_info
      integer i:=2;
     
      ST_INFO.town := "London";
      Year2017.town := "New York";
      Week.MgPlanete := 24; 
      ST_INFO.Week.MgPlanete  := 155;
      ST_INFO.ca := 12345.99;
        ST_INFO.BusinessValue[12] := 8888888.99; 
    	ST_INFO.Reference#SetValue("Reference Internal9988secret");
       
    

    Pre-requisites

    SCALAR AND/OR TABLE AND/OR STRUCT

    Remark

    None



    KEYWORD : ARRAY

    Definition

    Simple array with 1 dimension and n occurrences

    Syntax

      
     	
    	ARRAY : ArrayName OCCURS XXXX { scalar } ;   struct   
    	CHAR     :  ArrayName OCCURS XXXX;
    	INTEGER  :  ArrayName OCCURS XXXX;
    	LONG     :  ArrayName OCCURS XXXX;
    	FLOAT    :  ArrayName OCCURS XXXX;
    	DOUBLE   :  ArrayName OCCURS XXXX;
    	
    	 
    

    Example 1

      
      Array : Department OCCURS 10 { INTEGER Number ; CHAR Name :25 ; } ;
      
      BEGIN
       integer i :=2 ;
       Department[i].Number:= 99 ;
    	 
        Display " Department[2].Number :", Department[2].Number;
      END ;
       
    

    Example 2

     	
    CHAR    : Array : tableSAP :40 Occurs 10,     cVar:40 ;
    INTEGER : Array : Number0 Occurs 10 ;
    LONG    : Array : NumberL0 Occurs 10 ;
    FLOAT   : Array : MontantF Dec(2) Occurs 30;
    DOUBLE  : Array : MontantD Dec(4) Occurs 30;
    integer  x1:=25:	
    
     tablesap[1] := "PRPSS"; tablesap[2] := "PROJS";
     Number0[4]  := 99;
     NumberL0[6] := 199999;
     MontantF[x1] := 2000.02;
     MontantD[18] := 910002000.01234;
     cVar := "toto";
     Display " ";
     SetColorText (Hwdisplay:Blue,Red) ;
     		
    	Display "------------------------------------------------------------------------- " ;
    	Display "     ARRAY --------------------->SIMPLE! ....          " ;
    	Display "------------------------------------------------------------------------- " ;
     
    	SetColorText(Hwdisplay:green,black) ;
     display "CHAR: table 1  :" ,tablesap[1],"    table 2 :",tablesap[2],"     CVar :",cvar;
      skipline 2;
     display  "INTEGER: Number0[4] :" , Number0[4];
      skipline 2;
     display "LONG: NumberL0[6] :" , NumberL0[6];
      skipline 2;
     display "FLOAT: MontantF[25] :" , MontantF[x1];
      skipline 2;
     display "DOUBLE: MontantD[18] :" , MontantD[18];  
      
    

    Pre-requisites

    none

    Remarks

    NUMBER OF OCCURRENCES <999999 Advice: Create a temporary table: MS4_SQL{ ..} "CREATE VIEW TEMP name..." + SELECT..



    KEYWORD : TABLEBTREE

    Definition

    Simple Btree Memory array with 1 dimension and n data values

    Syntax

      
     	
    	 TABLEBTREE : nameTabletree
    		{ "constants".. };
    	
    	 
    

    Example

      
    		Tablebtree : Toto
    		{"Z" , " A", "B", "C", "EEF", " tuesday" ,"12", "20000" } ;
    
    	
    

    Pre-requisites

    none

    Remarks

    NUMBER OF CONSTANTS : no constraints

    See also

    TABLEBTREE_UPDATE, TABLEBTREE_INSERT, TABLEBTREE_DELETE,TABLEBTREE_DELETEALL,TABLEBTREE_DELETEALL,TABLEBTREE_LOOKUP,TABLEBTREE_GETSIZE,TABLEBTREE_TRACE






    KEYWORD : TABLEBTREE_UPDATE, TABLEBTREE_INSERT,TABLEBTREE_LOOKUP,
    TABLEBTREE_GETSIZE, TABLEBTREE_DELETE,TABLEBTREE_DELETEALL

    Definition

    Simple Btree Memory array with 1 dimension and n data values : UPDATE, INSERT + LOOKUP, DELETE, DELETEALL

    Syntax

      
     	
    	 	 TABLEBTREE_UPDATE(nameBtree, old value in btree, new value) (optional) return (0 or 1) (integer) ; 
    		 TABLEBTREE_INSERT(nameBtree,   new value);
    		 TABLEBTREE_LOOKUP(nameBtree,   new value) (optional)  return (0 or 1) (integer) ; 
    		 TABLEBTREE_GETSIZE(nameBtree) return value(integer) return (0 or 1) (integer)
    		 TABLEBTREE_DELETE(nameBtree,    value)(optional)  return (0 or 1) (integer) ; 
    		 TABLEBTREE_DELETEALL(nameBtree)(optional)  return (0 or 1) (integer); 
    	
    	 
    

    Example

      
    INTEGER :   X ;
    Tablebtree : Toto
    		{"Z" , " A", "B", "C", "EEF", " tuesday" ,"12", "20000" } ;
     	
    	 Tablebtree_Update(Toto,"12","999") Return(X); /* change 12 by 999 !!! */
     	IF (X Not_Void) 
    	THEN Display " Update it's OKKKKKKKKKKKKKK........12, and 999 :  ",X ;
    	ELSE Display " Update it's NOT  OK ........ 12 :   " ,X ;
    	END_If ;
    	
    	Tablebtree_Insert(Toto,"MGPLANETE");
    	Tablebtree_Lookup(Toto,"MGPLANETE") Return  (X);
    	IF (X Not_Void) 
    	THEN Display "  Found :  MGPLANETE"  ;
    	ELSE Display " NOT Found :MGPLANETE ";
    	END_If ;
    	Tablebtree_Getsize(toto) return(x);
        Display "Getsize TableBtree(toto) : ",x;
    	
    	Tablebtree_Delete(Toto,"EEF") Return(X); /* returning Not obligatoire */
     	IF (X Not_Void) 
    	THEN Display " Delete it's OKKKKKKKKKKKKKK........EEF :  ",X ;
    	ELSE Display " Delete it's NOT  OK ........ EEF :   " ,X ;
    	END_If ;
     
      Tablebtree_DeleteAll(Toto) ;** Clear All 
    	
    

    Pre-requisites

    DECLARE TABLEBTREE

    Remarks

    return value : 0 = not found or KO , 1= found or ok



    KEYWORD : TABLE STRINGXD, DOUBLEXD , FLOATXD, LONGXD, INTEGERXD

    Definition

    simple table with 1 to 3 dimensions for each variable type: string, double, float, long, and integer

    Syntax

      
     	
    table	 STRING1D :  varnameSTR1D  ;
    table    STRING2D :  varnameSTR2D  ; 
    table    STRING3D :  varnameSTR3D  ; 
        
    table	 DOUBLE1D :  varnameD1D  ;  
    table    DOUBLE2D :  varnamewntD2D  ;   
    table    DOUBLE3D :  varnamewntD3D  ;   
    
    table    FLOAT1D  :  varnamewntF1D  ;
    table    FLOAT2D  :  varnamewntF2D  ; 
    table    FLOAT3D  :  varnamewntF3D  ; 
    
    table  	LONG1D   :  varnamentL1D  ;  
    table   LONG2D   :  varnameL2D  ;   
    table   LONG3D   :  varnameL3D  ;   
     
    table	INTEGER1D   :  varnameI1D  ;  
    table	INTEGER2D   :  varnameI2D  ;   
    table	INTEGER3D   :  varname3D  ; 
     	
    	 
    

    Example 1

     	
    	table STRING1D :  STR1D  ;
        table STRING2D :  STR2D  ;
        table STRING3D :  STR3D  ;
    	
    	printlog(1);
    // ///////////////////////////////////////
    // 1Dim1
    // ///////////////////////////////////////
    	
    	BEGIN  // init size String
     	STR1D#SetSize(10)  ;// line
     	STR2D#SetSize(5,4)  ;// line , col
     	STR3D#SetSize(5,2,2)  ;// line , col ,depths
    	END ;
    	STR1D#setAt(0,"setAt Value ONE") ;
    	STR1D#setAt(1,"setAt Value TWO") ;
    	STR1D#setAt(2,"setAt Value 3") ;
     
      
    

    Pre-requisites

    none

    Remarks

    These are identical instructions for the double, float, long, and integer data types

    See also

    #SETSIZE,#RESIZE, #SETAT, #REMOVEAT, #ADDVALUE,/n #GETVALUE, #GETSIZE, #GETNBROW,#GETNBCOL, #GETNBDEPTHS,#CLEAR



    KEYWORD : TABLE : #SETSIZE,#RESIZE, #SETAT, #REMOVEAT, #ADDVALUE,/n #GETVALUE,#GETSIZE, #GETNBROW,#GETNBCOL, #GETNBDEPTHS,#CLEAR

    #b+c

    Definition

    unctions to handle tables with 1 to 3 dimensions for each type

    KEYWORD : #(hashtag)SETSIZE

    Definition

    function sizes the tables according to the expected dimension parameter, which can be 1, 2, or 3

    Syntax

      
     	
    	 	 varType1D#SETSIZE(integer )  1 dimension  ; 
    		 varType2D#SETSIZE(integer, integer )   2 dimensions; 
    		 varType3D#SETSIZE(integer, integer, integer )   3 dimension; 
     	
    	 
    

    Example

     	
     table STRING1D :  STR1D  ;
     table STRING2D :  STR2D  ;
     table STRING3D :  STR3D  ;
     
    // ///////////////////////////////////////
    // 1Dim1
    // ///////////////////////////////////////
    	
    	BEGIN  // init size String
     	STR1D#SetSize(10)  ;// nb line
     	STR2D#SetSize(5,4)  ;// nb line , nb col
     	STR3D#SetSize(5,2,2)  ;// line , col ,depths
    	END ;
    	 
      
    

    Pre-requisites

    none

    Remarks

    These are identical instructions for the double, float, long, and integer data types

    See also

    #RESIZE, #SETAT, #REMOVEAT, #ADDVALUE,/n #GETVALUE, #GETSIZE, #GETNBROW,#GETNBCOL, #GETNBDEPTHS,#CLEAR



    KEYWORD : #(hashtag)RESIZE

    Definition

    function re sizes the tables according to the expected dimension parameter, which can be 1, 2, or 3

    Syntax

      
     	
    	 	 varType1D#RESIZE(integer )  1 dimension  ; 
    		 varType2D#RESIZE(integer, integer )   2 dimensions; 
    		 varType3D#RESIZE(integer, integer, integer )   3 dimension; 
     	
    	 
    

    Example

     	
     table STRING1D :  STR1D  ;
     table STRING2D :  STR2D  ;
     table STRING3D :  STR3D  ;
     
    // ///////////////////////////////////////
    // 1Dim1
    // ///////////////////////////////////////
    	
    	BEGIN  // init size String
     	STR1D#ReSize(10)  ;// nb line
     	STR2D#ReSize(5,4)  ;// nb line , nb col
     	STR3D#RESize(5,2,2)  ;// line , col ,depths
    	END ;
    	 
      
    

    Pre-requisites

    none

    Remarks

    These are identical instructions for the double, float, long, and integer data types

    See also

    #SIZE, #SETAT, #REMOVEAT, #ADDVALUE,/n #GETVALUE, #GETSIZE, #GETNBROW,#GETNBCOL, #GETNBDEPTHS,#CLEAR



    KEYWORD : #(hashtag)SETAT

    Definition

    function initializes the values according to the table type and dimension.

    Syntax

      
     	
    	 	 varType1D#SETAT(integer, value )  1 dimension  ; 
    		 varType2D#SETAT(integer, integer , value)   2 dimensions; 
    		 varType3D#SETAT(integer, integer, integer , value)   3 dimension; 
     	
    	 
    

    Example

     	
     table STRING1D :  STR1D  ;
     table STRING2D :  STR2D  ;
     table STRING3D :  STR3D  ;
     .....SIZE,
    // ///////////////////////////////////////
    // 1Dim1
    // ///////////////////////////////////////
    	
    	STR1D#setAt(0,"setAt Value ONE") ;
    	STR1D#setAt(1,"setAt Value TWO") ;
    	STR1D#setAt(2,"setAt Value 3") ;
    	STR1D#setAt(3,"setAt Value 4") ;
       
    // ///////////////////////////////////////
    // 2Dim2
    // ///////////////////////////////////////
     
     	STR2D#setAt(0,0,"0 0 Value 1ONE2D") ;
      	STR2D#setAt(1,0,"1 0 Value 2ONE2D") ;
        STR2D#setAt(1,1,"1 1 Value 3ONE2D") ;
    // ///////////////////////////////////////
    //  Dim3
    // ///////////////////////////////////////
    	
    	STR3D#setAt(0,0,0,"3D 0 0 0 Value 1ONE3D") ;
      	STR3D#setAt(1,0,0,"3D 1 0 0 Value 2ONE3D") ;
        STR3D#setAt(1,1,1,"3D 1 1 1 Value 3ONE3D") ;
    	STR3D#GetValue(1,0,0) return str1;
    	 
      
    

    Pre-requisites

    #SIZE

    Remarks

    These are identical instructions for the double, float, long, and integer data types

    See also

    #SIZE , #RESIZE ,#SETAT, #ADDVALUE,/n #GETVALUE, #GETSIZE, #GETNBROW,#GETNBCOL, #GETNBDEPTHS,#CLEAR



    KEYWORD : #(hashtag)REMOVEAT

    Definition

    function deletes the record based on the parameters of this function

    Syntax

      
     	
    	 	 varType1D#REMOVEAT(integer )  1 dimension  ; 
    		 varType2D#REMOVEAT(integer, integer )   2 dimensions; 
    		 varType3D#REMOVEAT(integer, integer, integer )   3 dimension; 
     	
    	 
    

    Example

     	
     table STRING1D :  STR1D  ;
     table STRING2D :  STR2D  ;
     table STRING3D :  STR3D  ;
     
    // ///////////////////////////////////////
    // 1Dim1
    // ///////////////////////////////////////
    	.....SIZE, SETAT...
    	BEGIN  // delete record 
     	STR1D#RemoveAt(10)  ;//   line
     	STR2D#RemoveAt(5,4)  ;//   line ,   col
     	STR3D#RemoveAt(5,2,2)  ;// line , col ,depths
    	END ;
    	 
      
    

    Pre-requisites

    #SIZE, #SETAT

    Remarks

    These are identical instructions for the double, float, long, and integer data types

    See also

    #SIZE , #RESIZE ,#SETAT, #ADDVALUE,/n #GETVALUE, #GETSIZE, #GETNBROW,#GETNBCOL, #GETNBDEPTHS,#CLEAR



    KEYWORD : #(hashtag)GETVALUE

    Definition

    function returns the value based on the table type and the dimensions of this function

    Syntax

      
     	
    	 	 varType1D#GETVALUE(integer ) RETURN VALUE ; 1 dimension  ; 
    		 varType2D#GETVALUE(integer, integer ) RETURN VALUE  2 dimensions; 
    		 varType3D#GETVALUE(integer, integer, integer ) RETURN VALUE  3 dimension; 
     	
    	 
    

    Example

     	
     table STRING1D :  STR1D  ;
     table STRING2D :  STR2D  ;
     table STRING3D :  STR3D  ;
     
    // ///////////////////////////////////////
    // 1Dim1
    // ///////////////////////////////////////
    	.....SIZE, SETAT...
    	text str1;
    	integer : a,d,i , x ,y,z;
    	x := STR2D#getNbRow()  ;
       d :=  STR2D#getNbCol()  ;
     	 skipline 1;
     display "2D : getNbRow() : ",X,"  getNbCol() : ",d; 
    	for ( i:=0 ; i< x; i++ )
    	begin_for	
    	display " new Row/cols ---------------------------------------------------" ;
    		for ( y:=0; y< d;  y++)
    		begin_for	
    	 	STR2D#GetValue(i,y) return str1;
    		Display "STR2D#GetValue(i,y) 2D: nbRowe :  ",x," Dim1 : ",i," Dim2 : ",y," value : ",str1 ;
    		end_for;
    	end_for;	
    	END ;
    	 
      
    

    Pre-requisites

    #SIZE, #SETAT

    Remarks

    These are identical instructions for the double, float, long, and integer data types

    See also

    #SIZE , #RESIZE ,#SETAT, #REMOVEAT, #ADDVALUE,/n #GETSIZE, #GETNBROW,#GETNBCOL, #GETNBDEPTHS ,#CLEAR



    KEYWORD : #GETSIZE, #GETNBROW,#GETNBCOL, #GETNBDEPTHS

    Definition

    These functions return an integer: table size, number of records in the table, number of columns in the table, and table depth

    Syntax

      
     	
    	 	 varType1D#GETSIZE()  return integer; 
    		 varType1D#GETNBROW() return integer; 
    		 
    	 	 varType2D#GETSIZE()  return integer; 
    		 varType2D#GETNBROW() return integer; 
    		 varType2D#GETNBCOL() return integer; 
    		 
    	 	 varType3D#GETSIZE()  return integer; 
    		 varType3D#GETNBROW() return integer; 
    		 varType3D#GETNBCOL() return integer; 
     		 varType3D#GETNBDEPTHS() return integer;; 
    		 
     	
    	 
    

    Example

     	
     table STRING1D :  STR1D  ;
     table STRING2D :  STR2D  ;
     table STRING3D :  STR3D  ;
     
    // ///////////////////////////////////////
    // 1Dim1
    // ///////////////////////////////////////
    STR3D#getNbRow() return x;
     STR3D#getNbCol() return d;
     STR3D#getNbDepths() return z;
     	 skipline 1;
     display "3D : getNbRow() : ",X,"  getNbCol() : ",d,"  getgetNbDepths()  : ",z; 
     	
    	for ( i:=0 ; i< x; i++ )
    	begin_for	
    	display " new Row/cols ---------------------------------------------------" ;
    		for ( y:=0; y< d;  y++)
    		begin_for	
    			display " new Row/cols/depths ---------------------------------------------------" ;
     			for ( a:=0; a< z;  a++)
    			begin_for	
    				STR3D#GetValue(i,y,a) return str1;
    				Display "STR3D#GetValue(i,y) 3D: nbRowe :  ",x," Dim1 : ",i," dim2 : ",y," dim3 : ",a," value : ",str1 ;
    			end_for;
    		
    	  	end_for;
    	end_for;	
    	END ;
    
      
    

    Pre-requisites

    #SIZE, #SETAT

    Remarks

    These are identical instructions for the double, float, long, and integer data types

    See also

    #SIZE , #RESIZE ,#SETAT, #ADDVALUE,/n #GETVALUE, #GETSIZE, #GETNBROW,#GETNBCOL, #GETNBDEPTHS ,#CLEAR



    KEYWORD : #ADDVALUE

    Definition

    function allows adding records to the table by dynamically incrementing one additional dimension without invoking the SIZE or RESIZE functions. Note: Dimensions 2 or 3 are not affected by this function; you must respect the existing dimensions 2 and 3 according to the SIZE or RESIZE instruction

    Syntax

      
     
    	 	 varType1D#ADDVALUE(integer, value )  1 dimension  ; 
    		 varType2D#ADDVALUE(integer, integer , value)   2 dimensions; 
    		 varType3D#ADDVALUE(integer, integer, integer , value)   3 dimension; 
     	
    	 
    

    Example

     	
     table STRING1D :  STR1D  ;
     table STRING2D :  STR2D  ;
     table STRING3D :  STR3D  ;
     	 STR2D#getNbRow() return x;
    	 x++;
     	STR2D#AddValue(x,0,"9 0  2D AddValue-- Value ONE2D") ;
      	STR2D#AddValue(x,1,"9 1  2D AddValue-- Value ONE2D") ;
    
    
      
    

    Pre-requisites

    #SIZE, #SETAT optional

    Remarks

    These are identical instructions for the double, float, long, and integer data types

    See also

    #SIZE , #RESIZE ,#SETAT, #ADDVALUE,/n #GETVALUE, #GETSIZE, #GETNBROW,#GETNBCOL, #GETNBDEPTHS,#CLEAR



    KEYWORD : #CLEAR

    Definition

    function clears the entire table

    Syntax

      
     
    	 	 varType1D#CLEAR()  1 dimension  ; 
    		 varType2D#CLEAR()   2 dimensions; 
    		 varType3D#CLEAR()   3 dimension; 
     	
    	 
    

    Example

     	
     table STRING1D :  STR1D  ;
     table STRING2D :  STR2D  ;
     table STRING3D :  STR3D  ;
     	..SIZE, RESIZE, SETAT, ADDVALUE..
    	 STR1D#Clear() ;
         STR2D#Clear() ;  
         STR3D#Clear() ; 
    
    
      
    

    Pre-requisites

    #SIZE, #SETAT, #ADDVALUE

    Remarks

    These are identical instructions for the double, float, long, and integer data types

    See also

    #SIZE , #RESIZE ,#SETAT, #ADDVALUE,/n #GETVALUE, #GETSIZE, #GETNBROW,#GETNBCOL, #GETNBDEPTHS

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


    The official sites :


    Copyright 2020 by Mandragore Planete


    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