jSqliteDataAccess

type jSqliteDataAccess = class(jControl)

default

const

  POSITION_UNKNOWN = - 1

protected

  function GetEOF;

  function GetBOF;

  procedure Notification(); override;

public

  constructor Create(); override;

  destructor Destroy; override;

  procedure Init; override;

  function ExecSQL();

  function CheckDataBaseExists();

  procedure OpenOrCreate();

  procedure SetVersion();

  function GetVersion;

  procedure AddTable();

  procedure CreateAllTables;

  function Select();

  procedure SetSelectDelimiters();

  function CreateTable();

  function DropTable();

  function InsertIntoTable();

  function DeleteFromTable();

  function UpdateTable();

  function UpdateImage();

  procedure Close;

  function GetCursor; overload;

  procedure MoveToFirst;

  procedure MoveToNext;

  procedure MoveToPrev;

  procedure MoveToLast;

  procedure MoveToPosition();

  function GetRowCount;

  function GetColumnCount;

  function GetColumnIndex();

  function GetColumName();

  function GetColType();

  function GetValueToString();

  function GetValueAsString();

  function GetValueAsBitmap();

  function GetValueAsInteger();

  function GetValueAsDouble();

  function GetValueAsFloat();

  function GetPosition;

  procedure SetForeignKeyConstraintsEnabled();

  procedure SetDefaultLocale;

  procedure DeleteDatabase();

  function InsertIntoTableBatch();

  function UpdateTableBatch();

  function CheckDataBaseExistsByName();

  procedure UpdateImageBatch();

  procedure SetDataBaseName();

  function GetFullPathDataBaseName;

  function DBExport();

  function DBImport();

  function Insert();

  function Update();

  function UpdateAll();

  function Delete();

  function DeleteAll();

  procedure ContentValuesClear;

  procedure PutString();

  procedure PutShort();

  procedure PutLong();

  procedure PutDouble();

  procedure PutInteger();

  procedure PutBoolean();

  procedure PutFloat();

  procedure PutByte();

  function DatabaseExists();

  procedure SetAssetsSearchFolder();

  procedure SetReturnHeaderOnSelect();

  procedure SetBatchAsyncTaskType();

  procedure ExecSQLBatchAsync();

  procedure GenEvent_OnSqliteDataAccessAsyncPostExecute();

  property FullPathDataBaseName: string; [r]

published

  property Cursor: jSqliteCursor; [rw]

  property ColDelimiter: char; [rw]

  property RowDelimiter: char; [rw]

  property DataBaseName: string; [rw]

  property CreateTableQuery: TStrings; [rw]

  property TableName: TStrings; [rw]

  property ReturnHeaderOnSelect: Boolean; [rw]

  property OnAsyncPostExecute: TOnSqliteDataAccessAsyncPostExecute; [rw]

  property EOF: Boolean; [r]

  property BOF: Boolean; [r]

end;

jSqliteDataAccess

jControl

TObject