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
MS4BI
     

BASIC HELP : MS4BI Designer by MS4script

2021 version 1

LISTBOX - COMBOBOX

Definition

  • Declare a variable to be entered or selected from a listbox or a combobox
  • Update ou Delete Cycle: the selection button allows either to choose the record to be modified or deleted
  • Insert Cycle: the selection button allows you to choose a referential of the table belonging to the InputSelect variable
  • Syntax

      	
     <Listbox    : name="var1"    like : table("xxx")  label="ListboxXXX" >;   
     <Combobox   : name="var2"    like : table("xxx")  label="ComboxXXX" >; 
    
    

    KEYWORD :
    BEGIN_FORM <listbox, combobox...Submit()... END_FORM

      	
    Begin_transaction ; nameTRS  
      cycle : insert table xxxx, update table xzzzzn delete Row table xx.. 
      begin_form  
       <listbox, combobox.InputSel.. var2..submit
       End_form ; 
           Chart or dashboard or image or grid....
      End_transaction ;  
    
    

    MG PLANETE

    • contact@mgplanete.com
    • 15 rue des Halles 75001 PARIS FR
    • Contact: 00 33 (0)1 76 46 09 83