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..
String functions Str..()
Get + Include functions Get, Include..
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
Data Insert
Process

METHOD 1 : ROW

     

BASIC HELP : MS4BI Designer by MS4script

2021 version 1

INPUT SELECT

Definition

  • To declare an input variable along with a selection button
  • Update or Delete cycle: use the selection button to select the record to be updated or deleted
  • Insert cycle: use the selection button to select a repository for the table referenced in the InputSelect variable
  • Syntax

      	
     <InputSelect  : type="text"  name="NAME" like : table("People")  class=standardMs4  placeholder="please select-MONTH-"   >; 
      <button + GetSelectPop()   :  $Bts_btn_success_btn_sm  ,  icon   :  $fa_1x + $fa_search  , text : "Select" > ; 
    
    

    KEYWORD :
    BEGIN_FORM inputselect,Inputdata...Submit()... END_FORM

      	
    Begin_transaction ; nameTRS  
      cycle : insert table xxxx, update table xzzzzn delete Row table xx.. 
      begin_form  
       inputselect  var1 ..InputSel.. 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
  • 3 – Add a button: Submit
  • See the Help: Settings
  • MS4BI will format BEGIN_FORM..END_FORM blocks for the appropriate cycle on generation

  • Example 1

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

    Begin_FormWeb ** INSERT

       position:position:2585,282,40,124 :
    <InputSelect type="text" name="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" name="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" name="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" name="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 : -ADD/Delete -
    FIRSTNAMENAMEAGESEX Options Add
    Sheila Arthur 28 F Delete
    Steven Buchanan 61 M Delete
    Laura Callahan 36 F Delete
    Nancy Davolio 39 F Delete
    John Devis 21 M Delete
    Anne Dodsworth 27 F Delete
    Andrew Fuller 28 M Delete
    Donald Hallan 33 M Delete
    Robert King 34 M Delete
    Peter Mactree 42 M Delete
    patrick Nevada 23 M Delete
    Margaret Peacock 42 F Delete
    Jack Picsou 57 M Delete
    Michael Suyama 26 M Delete

      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