How to execute a query directly without prepare, unprepare
lazarus / 16-Databases

----------------------------------------------------------------------
mek · 2018-11-25 04:02

In procedure TSQLConnection.ExecuteDirect,
Every sql query go through
Quote   
PrepareStatement(Cursor,ATransaction,SQL,Nil);
Execute(Cursor,ATransaction, Nil);
UnPrepareStatement(Cursor); 
Is there a way to execute sql without prepare?

----------------------------------------------------------------------
Thaddy · 2018-11-25 11:31

executedirect?

----------------------------------------------------------------------
mangakissa · 2018-11-27 09:02

Don't use the execute of TSQLConnection, but the TSQLquery.execsql.
SQLdb doesn't prepare the query. Your database does. It prepares the
query to check if the query is valid. Then it will executed. It also
caches you query to use it if the query is the same.