BASIC HELP : MS4BI Designer by MS4script   
   2021 version 1       

TRANSACTION

KEYWORD : BEGIN_TRANSACTIONWEB ...END_TRANSACTIONWEB

Definition

Creates a Web Transaction with MS4BI DESIGNER

Syntax

  	
 Begin_transaction ; nameTRS 
  cycle : insert table xxxx, update table xzzzz.. 
or nocyle
 begin_form
   input ..
 End_form ;
       Chart or dashboard or image or grid....
  End_transaction ; 	
	

Example 1

 		   
 Begin_TransactionWeb : "00-Transaction" ,  
  Cycle :  NoCycle ;  
 backgroundColor: color(218,218,218) ; 
  position :  69,128,auto,auto : 
   FormPlus : DrawQrCODE type : $URL ("https://getms4bi.com") ; 
 BEGIN 
 MS4_SQL{ms4db}("  DROP   VIEW IF EXISTS  tmp_gentable_ms40001   "); 
 MS4_SQL{ms4db}("  CREATE TEMPORARY VIEW IF NOT EXISTS  tmp_gentable_ms40001  AS  "+ 
\  "  select sex,age from people " );
 position :  103,1235,auto,auto : 
   setting :   chart : legend : 0 Redraw : 1,counter :99  ; 
 FormPlus :	DrawPie ,height : "209", width : "326" title :"" , ANGLE :150 ,  TYPE : $Standard , 
  FORMAT: ""  use   View  ("tmp_gentable_ms40001") ; 
 END ; 
  End_TransactionWeb ;  

Export

Export All transactions/Application + Bd

Export

Export this transaction + Db

Submit

Generation MS4script + Submit

Toolbar

Objets : Setting, Text, Edit,Check,Combo..Report, Grid, formula(chart), image,QrCode, TabStrip,Import
objects are described in the examples in this help