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 13 : WINDOWS

KEYWORD : PICTUREXXX

Definition

Displays an image (BMP, GIF, WMF, ICON, JPG) in a Windows dialogue box.

Syntax

  		   	
 PICTUREXXX Windows coordinates x , y , STRING the image directory, VarWinName 
PICTUREXXX Replace by: PICTUREBMP displays a BITMAP type image PICTUREGIF displays a GIF or animated GIF type image PICTUREICON displays an ICON type image PICTUREWMF displays a WMF type image PICTUREJPG displays a JPG or JPEG type image

Example

  	
#include  "#SYSPATHMS4BI+\zInclude\IncludeSysMs4Windows.h"     
Begin_Main
MANDRAGORESOFT_SP_SCRN(Void);

End_Main
 PROC MANDRAGORESOFT_SP_SCRN(Void)
begin_proc
	
	Begin_Splash
		WinExtendStyle : :Ws_Ex_transparent
		WinStyle 	 :  CenterDialog
		1,1, 218,  98, " MS4BI  :  LOGO ",UserDialog
		
		PictureJPG 1, 1, "#SYSPATHMS4BI+\zPicture\Jpg\mgplanete.jpg",Jpgms41
		
	End_Splash ;
	
	ShowSplash (UserDialog: 4500) ;
	
	SetStatusDialog(UserDialog:Sw_HIDE);
end_proc
	

Picture 1

Prerequisites

#include "#SYSPATHMS4BI+\zInclude\IncludeSysMs4Windows.h"
BEGIN_TRANSACTION..END_TRANSACTION
BEGIN_DIALOG..END_DIALOG

Remarks

This example :
driver:\MandragorePlanete\MS4BI\zDemo-Simple\Windows\win-00-database1.db-logo.ms4
\

See also

FRAME ,BUTTONXXXXX,PRESSED



KEYWORD : FRAME

Definition

Displays a FRAME in a Windows dialogue box.

Syntax

  		   	
 Frame x, y,(height) integer, (width) integer , VARWINFRAMEx Attribute :
FillColor : rgb red color ,rgb green color,rgb blue color
FrameColor : rgb red color ,rgb green color,rgb blue color
ShadowText : shadow offset integer 1, shadow offset integer 2
Color(rgb red colour, rgb green colour, rgb blue colour)
SetColorText : rgb red colour,rgb green colour, rgb blue colour
DrawText : DT_CENTER or DT_LEFT or DT_RIGHT or DT_VCENTER or DT_BOTTOM
SetFonts : Height, Width, Escapement, Orientation, Weight, Italic,
Underline, StrikeOut, CharSet, OutPrecision, ClipPrecision, Quality, PitchAndFamily, pszFaceName)

Example

  	
#include  "#SYSPATHMS4BI+\zInclude\IncludeSysMs4Windows.h"     
Begin_Transaction : Trans1 Execute Transaction With VarExit != 1	
Begin_Dialog		
                     BackgroundColor : Color(192,193,218)
 			WinExtendStyle :  :WS_EX_CLIENTEDGE
			WinStyle 	   :  :WS_OVERLAPPED & CenterDialog
	 		1, 1, 800,600, "MS 4  : Presentation  ",UserDialog
 			
			
		Frame 10, 2,750, 50, Wtitle1 Attribute :
			FillColor : 144,136,176
			FrameColor : 250,250,250
			ShadowText : 1,2 Color(0,0,0)
			SetColorText : 185,8,90
			DrawText : Dt_CENTER
			SetFonts :
			30,18,0,0,Fw_EXTRABOLD,0,0,0,"Calibri"	
 	 
End_Dialog	
   	Begin_Initialize
			SetWinTxt(Wtitle1:"   MS4BI : Ultra light, Simple , Agile && Full Responsive ");
	    			
	 End_Initialize          
	OpenDialog (UserDialog1); 
  	instruction
	instruction Exit transaction for VarExit
  
End_Transaction ;
	

transaction 2

Prerequisites

#include "#SYSPATHMS4BI+\zInclude\IncludeSysMs4Windows.h"

Prerequisites

#include "#SYSPATHMS4BI+\zInclude\IncludeSysMs4Windows.h"
BEGIN_TRANSACTION..END_TRANSACTION
BEGIN_DIALOG..END_DIALOG

Remarks

The BEGIN_INITIALIZE block is used to initialise the content of the Win FRAME variable.
\

See also

PICTUREXXX ,BUTTONXXXXX,PRESSED



KEYWORD :BUTTONXXXXX and PRESSED

Definition

- Displays a TEXT or ICON button in a Windows dialogue box.
- Displays a REGION type button (clickable area) in a Windows dialogue box.
- PRESSED : Returns TRUE (1) if the button is PRESSED, otherwise FALSE (0)

Syntax

  	
- ButtonText or ButtonRegionChild or ButtonPush
x, y,(height) integer, (width) integer , " literal ", VarwinButton Create : (optional) Info " literal", (info bubble) Use Cursor " Cursor directory " - BUTTONICON OR BUTTONICONDRAWLABEL Width Icon:integer ,Height Icon : integer , x, y,(height) integer, (width) integer , " ICON directory ", VarwinButton Create : Text : " literal", Info " literal", (info bubble) Use Cursor " Cursor directory " - require (optional) integer = PRESSED(VarWinButton);

Example

  	
#include  "#SYSPATHMS4BI+\zInclude\IncludeSysMs4Windows.h"     
Begin_Transaction : Trans1 Execute Transaction With VarExit != 1	
Begin_Dialog		
                     BackgroundColor : Color(192,193,218)
 			WinExtendStyle :  :WS_EX_CLIENTEDGE
			WinStyle 	   :  :WS_OVERLAPPED & CenterDialog
	 		1, 1, 800,600, "MS 4 : Presentation  ",UserDialog
 			
			ButtonRegionChild 2,540,48,48, ButtonQuit 
			Create : 
			Info " Option       @   Exit     ",
			Use Cursor "#SYSPATHMS4BI+\zPicture\Cursor\hand-l.cur" ,
			PictureGIF 60, 540,"#SYSPATHMS4BI+\zPicture\Gif\GifAnimate\iExplorer.gif",Gifexplorer ** or constante path or see you : loadPicture ..
			
			ButtonText 140 ,540, 180,25, "  www.mgplanete.com ", Buttonwww
			Create :	
			Info " Internet  @  www.mgplanete.com",
			Use Cursor "#SYSPATHMS4BI+\zPicture\Cursor\hand-l.cur"  
	
			Buttonicondrawlabel Width Icon: 24 ,Height Icon : 24 ,  
			1,545,80,45, "#DRIVERSYS+\MandragorePlanete\MS4BI\zPicture\Icon\XP\cancelxp.ico",Boutoncancel 
			Create :	Text "exit " ,Info " Option   @ Exit "
			Use Cursor "#DRIVERSYS+\MandragorePlanete\MS4BI\zPicture\Cursor\hand-l.cur" 

End_Dialog	
   	OpenDialog (UserDialog1); 
  		BEGIN /*   Click on MANDRAGORE Site */ 

			Require  x := Pressed  (Buttonwww) ;
			IF (X Not_Void) THEN SetHourGlassCursor();
				Internet_Navigate("www.mgplanete.com"); 	
			End_if ;
		END  ;
        BEGIN /* Exit Transaction */
 			Require  x := Pressed(ButtonQuit);
			IF (X Not_Void) THEN 
				SetStatusDialog(UserDialog:Sw_HIDE);
				Exit_TRANS1 := 1 ;
			End_if;
		END  ; 
		OR
        BEGIN /* Exit Transaction */
 			Require  x := Pressed(ButtonCancel);
			IF (X Not_Void) THEN 
				SetStatusDialog(UserDialog:Sw_HIDE);
				Exit_TRANS1 := 1 ;
			End_if;
		END  ;  		
End_Transaction ;
	

transaction 3

Prerequisites

#include "#SYSPATHMS4BI+\zInclude\IncludeSysMs4Windows.h"
BEGIN_TRANSACTION..END_TRANSACTION
BEGIN_DIALOG..END_DIALOG

Remarks

This example :
driver:\MandragorePlanete\MS4BI\zDemo-Simple\win-00-database1.db.ms4
- the PRESSED function is necessary to return a TRUE (1) value if the button is selected.

See also

PICTUREXXX, FRAME, PRESSED



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