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 : Form ROW

     

BASIC HELP : MS4BI Designer by MS4script

2021 version 1


CYCLE : DELETE



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

  	
Begin_transaction ; nameTRS  
  cycle   : insert table xxxx, update table xzzzzn  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
  • Delete cycle: possible combination; check Delete or Update/Delete or Insert/Delete
  • 3 – Add a button: Submit

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

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

    Begin_FormWeb ** DELETE

       position:position:2585,282,40,124 :
    <InputSelect .....    position:position:2742,288,35,135 :
    <InputData: ....    position:position:2834,270,74,144 :
    <InputData: type=SubmitForm() class="btn btn-lg btn-primary" attrib="value='Submit (ADD)' " >;     position : 2553,568,43,148:
    <button + SetDeleteRow("people" ) : $Bts_btn_info_btn_sm , icon : $fa_1x + $fa_eraser , text : "Delete Last Select" > ;   

    End_FormWeb ;

       ....

    IMPLEMENTATION

    METHOD 2 : LIST EDIT : -Delete -
    FIRSTNAMENAMEAGESEX Options
    Sheila Arthur 28 F Delete
    Steven Buchanan 61 M 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
    Janet Leverling 52 F 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