[Lazarus] SQLdb: Pseudo Transaction?

[R.Smith]

On 2020/06/30 22:52, Special via lazarus wrote:
> Hi, Ryan,
>
> I followed your advice and removed XTransaction and all references to 
> it from TestButtonClick. But now I get an exception with the message 
> "Transaction not set". Any hint?
> Regards --  Joe

I'm sorry, the previous problem was SQLite-related, which I'm 
initimately familiar with, but this one seems to be a Lazarus DB 
component requirement which I'm not so much familiar with, but probably 
has an easy solution someone here might know about.

The question becomes:  How to execute a query, without a transaction 
being set, using SQLdb in Lazarus?


PS: In case you wonder, we're in the process of porting an existing 
SQLite management tool (https://sqlitespeed.com) to open-source 
multi-platform from Delphi to FPC and Lazarus - It's been quite a job 
but going well, and I love the Lazarus/FPC environment more and more, 
will never go back to Delphi/VS. I do however access SQLite through the 
API rather than the SQLdb provided components, which is why I can tell 
you lots about SQL and SQLite but not so much about SQLdb... So 
apologies for that - hope someone can answer this with some more 
pertinent knowledge.