ESQLiteError locate causing SQL-Query
Posted: Wed 27 Jan 2021 14:12
Hello,
it is possible to determine and display the causing SQL command within an ESQLiteError command.
It would also suffice to find out the TLiteQuery components that caused it.
ESQLiteError.Component supplies the connection. Can I use it to determine the last command or TLiteQuery component that was executed. Anything like that would help me.
Or is it because of SQLite that it does not provide enough information and therefore LiteDac can no longer deliver.
Otherwise it would possibly be in the LiteDac source code in one of the next versions that for each TLiteQuery.Excecute / Open its name would be "noted" in the TLiteConnection. You can then access the information via ESQLiteError.Component.
This question also applies to MyDac. So everywhere in the above text replace Lite [/ i] with My [/ i] ..
it is possible to determine and display the causing SQL command within an ESQLiteError command.
It would also suffice to find out the TLiteQuery components that caused it.
ESQLiteError.Component supplies the connection. Can I use it to determine the last command or TLiteQuery component that was executed. Anything like that would help me.
Or is it because of SQLite that it does not provide enough information and therefore LiteDac can no longer deliver.
Otherwise it would possibly be in the LiteDac source code in one of the next versions that for each TLiteQuery.Excecute / Open its name would be "noted" in the TLiteConnection. You can then access the information via ESQLiteError.Component.
This question also applies to MyDac. So everywhere in the above text replace Lite [/ i] with My [/ i] ..