Is it possible to get some kind of result after a query has been executed? For example, when a query executes for dropping a table and creating a table, it would be nice if there is an event which can inform the application what the query did. I found the onafter events but only OnAfterExecute seems triggert.
Below you find my code for dropping and creating a table in SQLite.
Code: Select all
UniQuery->SQL->Text =
"DROP TABLE IF EXISTS [contacts];"
"\r\n"
"CREATE TABLE [contacts] ("
"[contact_id] INTEGER PRIMARY KEY,"
"[first_name] TEXT NOT NULL,"
"[last_name] TEXT NOT NULL,"
"[email] TEXT NOT NULL UNIQUE,"
"[phone] TEXT NOT NULL UNIQUE"
");";
UniQuery->Execute();