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
Process

METHOD 1 : ROW

     

BASIC HELP : MS4BI Designer by MS4script

2021 version 1

CYCLE : UPDATE

Syntax

  	
  <InputSelect or InputData  : type="text or number.."  name="NAMEVAR" like : table("XXXXX")  class=standardMs4  placeholder="please select-MONTH-"   >; 
    <button + GetSelectPop()   :  $Bts_btn_success_btn_sm  ,  icon   :  $fa_1x + $fa_search  , text : "Select" > ; 

KEYWORD :
BEGIN_FORM inputdata,Inputselect...Submit()... END_FORM

  	
Begin_transaction ; nameTRS  
  cycle :  insert table xxxx;  update table xzzzz  ; delete Row table xx.. ;
  begin_form  
   input var1 ..Input var2..submit
   End_form ; 
       Chart or dashboard or image or grid....
  End_transaction ;  

Method and Settings option


  • 1 - Draw the variables: InputData or Select
  • 2 - Select option 1 Settings to determine the cycle: INSERT OR UPDATE and/or DELETE
  • Update cycle: possible combination; check Update or Update/Delete : Insert option unavailable
  • 3 – Add a button: Submit
  • See the Help: Settings

  • Update Cycle: possible combination: check Update or Update/Delete: Insert option Impossible
  • Example 1

      	   
     Begin_TransactionWeb : "02-DataEditADD" , 
        Cycle :  
       updatet :  table "people" ;  
      

    Begin_FormWeb ** UPDATE

       position:position:2585,282,40,124 :
    <InputSelect type="text" IDname="NAME" like : table("people") class=standardMs4 placeholder="please select-NAME-" >;    position:position:2587,418,auto,auto :
    <button + GetSelectPop() : $Bts_btn_success_btn_sm , icon : $fa_1x + $fa_search , text : "Select" > ;    position:position:2642,287,41,142 :
    <InputSelect type="text" IDname="FIRSTNAME" like : table("people") class=standardMs4 placeholder="please select-FIRSTNAME-" >;    position:position:2644,441,auto,auto :
    <button + GetSelectPop() : $Bts_btn_success_btn_sm , icon : $fa_1x + $fa_search , text : "Select" > ;    position:position:2702,289,31,90 :
    <InputSelect type="text" IDname="SEX" like : table("people") class=standardMs4 placeholder="please select-SEX-" >;    position:position:2704,391,auto,auto :
    <button + GetSelectPop() : $Bts_btn_success_btn_sm , icon : $fa_1x + $fa_search , text : "Select" > ;    position:position:2742,288,35,135 :
    <InputData: type="int" IDname="AGE" like : table("people") class=standardMs4 placeholder="-AGE-" >;    position:position:2834,270,74,144 :
    <InputData: type=SubmitForm() class="btn btn-lg btn-primary" attrib="value='Submit (ADD)' " >;   

    End_FormWeb ;

       ....

    IMPLEMENTATION

    METHOD 2 : LIST EDIT : - Edit= Update -
    FIRSTNAMENAMEAGESEX Options
    Sheila Arthur 28 F Edit
    Steven Buchanan 61 M Edit
    Laura Callahan 36 F Edit
    Nancy Davolio 39 F Edit
    John Devis 21 M Edit
    Anne Dodsworth 27 F Edit
    Andrew Fuller 28 M Edit
    Donald Hallan 33 M Edit
    Robert King 34 M Edit
    Janet Leverling 52 F Edit
    Peter Mactree 42 M Edit
    patrick Nevada 23 M Edit
    Margaret Peacock 42 F Edit
    Jack Picsou 57 M Edit
    Michael Suyama 26 M Edit
      METHOD 3 : LIST EDIT : - Edit Line = Update -
      FIRSTNAMENAMEAGESEX Options

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

        the official sites :
        www.mgplanete.com
        getms4bi.com
        demos.ms4bi.com
        help.ms4bi.com
        www.ms4script.com