_executeQuery

Documentation: Usage of `_executeQuery` Function

Overview:

The _executeQuery function allows you to execute a SQL query directly from your JavaScript code. The function sends the query to the database and returns the result set as a JSON-encoded string. This function is particularly useful for retrieving data from a database within your on-premise environment.

Function Signature:

Parameters:

query: A string representing the SQL query that you want to execute. This must be a valid SQL statement (e.g., SELECT, UPDATE, INSERT, etc.). The query should not be empty or null.

Return Value:

string: The function returns a JSON-encoded string containing the result set of the executed query. Each row from the result set is converted into a JSON object, with the column names as keys and their corresponding values as the object values.

Error Handling:

Ensure that the query parameter is a valid and properly formatted SQL statement. If the query is invalid or empty, the function may not execute correctly, and you will need to handle errors in your JavaScript code.

Example Usage:

1. Basic Example: Fetching Data

This example demonstrates how to use _executeQuery to fetch data from a database.

2. Error Handling Example: Handling Invalid Queries

It's essential to handle cases where the query might be invalid.

Best Practices:

Always validate your SQL queries before passing them to _executeQuery to avoid errors.

Parse the JSON response using JSON.parse() to convert the JSON string into JavaScript objects for further manipulation.

This documentation should help you effectively use the _executeQuery function in your JavaScript code to interact with your database and handle the results.

_executeQuery

Documentation: Usage of _executeQuery Function#

Overview:#

Function Signature:#

Parameters:#

Return Value:#

Error Handling:#

Example Usage:#

1. Basic Example: Fetching Data#

2. Error Handling Example: Handling Invalid Queries#

Best Practices:#