MS4BI and Database Management

Why SQLite3 for MS4BI?

Built-in SQLite3 Manager

MS4BI includes a SQLite3 manager similar to phpMyAdmin, allowing:

✔ An intuitive interface to easily manage your databases.

✔ An SQL editor to execute queries.

✔ Optimized import/export management.

Full Control with MS4Script

MS4Script enables SQLite3 manipulation with simple commands:

• ✔ Database creation and management.
• ✔ Execution of complex SQL queries.
• ✔ Automated backup and restoration.

🔍 MS4Script Code Example

// Connect to an SQLite3 or MS4BI database
DBconnect {Ms4DB} ("h:\Mandragore...\Ms4BI-DemoExcelCube.dbLcurrentdb"); 

// Connect to an Excel database via ADO
DBconnect {Ado:\"xls\"}( LFile1Excel); 

// Execute an SQL query from an Excel sheet
Ms4_SQL{Ado:\"xls\"}("SELECT * INTO " + "%s" + " FROM [table1] ",SheetJapanese) RETURN x; 

// Connect to an Excel database (MS4BI internal manager)
DBconnect {xlsx}( LFile1Excel); 

// Execute an SQL query from an Excel sheet
Ms4_SQL{xlsx}("SELECT * INTO " + "%s" + " FROM [table1] ",SheetJapanese) RETURN x;