[SOLVED] Can database auto-connected in fcl-web applications?
lazarus / 38-Networking and Web Programming

----------------------------------------------------------------------
egsuh · 2020-11-02 09:00

I put an TIBConnection, TSQLTransaction, and TSQLQuery and wrote a
simple CGI application just returning the content of a table. This
runs well, even though I myself do not set TIBConnection.Connected :=
True. This this possible?

In HTTPServer it does not.

----------------------------------------------------------------------
lucamar · 2020-11-02 13:30

It should be possible if you set IBDatabase.Connected and
SQLTransaction.Active to True at design-time, though that is not
generally recommended: if the database doesn't exist at run-time,
having those set will make the up barf up a couple of exceptions when
launched, which is not really a nice thing, specially for a CGI

----------------------------------------------------------------------
Sieben · 2020-11-02 13:54

If you Open a TSQLQuery it's TXYZConnection will be implicitly set
Connected, and a TSQLTransaction wired to it will be set Active as
well.

----------------------------------------------------------------------
egsuh · 2020-11-02 14:10

Quote if you set IBDatabase.Connected and SQLTransaction.Active to
True at design-time,No. If I did set connected and active true, then
it's natural. But both were false.

QuoteIf you Open a TSQLQuery it's TXYZConnection will be implicitly
set Connected, and a TSQLTransaction wired to it will be set Active as
well. I see. That's why it acted in that way. Interesting thing is
setting transaction wired to an unconnected database raises exception.