Getting Started with the Demo

1. Installation:

   • Download and install the "Local Query Engine (SQLite) - Demo" application from the OutSystems Forge.
   • Ensure that you have already installed the main "Local Query Engine (SQLite)" component, as the demo depends on it for SQL execution.

2. Demo Overview:

   • The demo application includes a user-friendly interface that demonstrates how to execute different types of SQL commands using the Local Query Engine (SQLite) component.
   • It provides examples of executing DQL (Data Query Language), DDL (Data Definition Language), and DML (Data Manipulation Language) commands on the local SQLite database.

Features Demonstrated in the Demo

1. Executing SQL Queries:

   • The demo showcases how to use the ExecuteQuery client action to run SQL commands such as SELECT, INSERT, UPDATE, DELETE, CREATE TABLE, and DROP TABLE.
   • It demonstrates how to handle the results of these queries, including retrieving data and confirming successful command execution.

2. Database to JSON Conversion:

   • The application includes examples of using DatabaseToJSONMobile and DatabaseToJSONWeb client actions to convert local database data into JSON format.
   • It demonstrates how to utilize the JSON data within the application for various purposes, such as displaying data in a list or synchronizing with a remote server.

3. Web Block Integration:

   • The demo shows how to properly integrate the Local Query Engine (SQLite) web block into your screens.
   • It illustrates the importance of including this web block to load the necessary JavaScript files for executing SQL queries.

4. Interactive SQL Command Execution:

   • The demo allows you to input custom SQL commands and execute them directly within the application.
   • This interactive feature helps you understand the component's capabilities and how it handles different SQL operations.

Getting Started with the Demo

1. Installation:

   • Download and install the "Local Query Engine (SQLite) - Demo" application from the OutSystems Forge.
   • Ensure that you have already installed the main "Local Query Engine (SQLite)" component, as the demo depends on it for SQL execution.

2. Demo Overview:

   • The demo application includes a user-friendly interface that demonstrates how to execute different types of SQL commands using the Local Query Engine (SQLite) component.
   • It provides examples of executing DQL (Data Query Language), DDL (Data Definition Language), and DML (Data Manipulation Language) commands on the local SQLite database.

Features Demonstrated in the Demo

1. Executing SQL Queries:

   • The demo showcases how to use the ExecuteQuery client action to run SQL commands such as SELECT, INSERT, UPDATE, DELETE, CREATE TABLE, and DROP TABLE.
   • It demonstrates how to handle the results of these queries, including retrieving data and confirming successful command execution.

2. Database to JSON Conversion:

   • The application includes examples of using DatabaseToJSONMobile and DatabaseToJSONWeb client actions to convert local database data into JSON format.
   • It demonstrates how to utilize the JSON data within the application for various purposes, such as displaying data in a list or synchronizing with a remote server.

3. Web Block Integration:

   • The demo shows how to properly integrate the Local Query Engine (SQLite) web block into your screens.
   • It illustrates the importance of including this web block to load the necessary JavaScript files for executing SQL queries.

4. Interactive SQL Command Execution:

   • The demo allows you to input custom SQL commands and execute them directly within the application.
   • This interactive feature helps you understand the component's capabilities and how it handles different SQL operations.