GenericQuery

Class component a easily way to convert your SQL condition to a JSONArray or JSONString. Default database is running in firebird. To change only modify Mode.Connection uses.

How to use

Implement this parameters:

  Model.Connection.FServer := 'localhost';
  Model.Connection.FDataBase := '../../db/db';
  Model.Connection.FTypeConnection := SQLite;

Compatible with Firebird and SQLite.

Execute

Execute command returns a boolean value.

  TGenericQuery
    .New
    .SQL('')
    .SQL('')
    .Execute

OpenArray

Open a Array of JSON Objects with fields data

  TGenericQuery
    .New
    .SQL('')
    .SQL('')
    .OpenArray

OpenObject

Open a JSON Object with only first register of sql

  TGenericQuery
    .New
    .SQL('')
    .SQL('')
    .OpenObject