Hello all,
I am converting a huge ZeosLib database application to FireDac under Delphi XE 10. All queries are executed by setting the SQL.Text property at runtime. On some queries I get exception messages like this:
[FireDAq[Phys][SQLite] ERROR: near';": syntax error
The fix for this problem is to remove semicolons from the end of SQL statements.
I am wondering if there is a property I can change and keep semicolons at the end of SQL statements to avoid mass changes?
Thank you.