mORMot Open Source

dcoun

Member

From: Crete, Greece

Registered: 2020-02-18

Posts: 430

Mormot2: Setting fDatabase.ResourceOptions for Firedac

Looking to set the TfdConnection.ResourceOptions for manual queries from interface functions (using the mormot's connection pool), I found that it is not possible without changing the Mormot2 source.
I can get a TSqlDBFireDACConnection but it is not possible to set the fDatabase.ResourceOptions because it is readonly as a property.
I need to disable Macros (MacroCreate, MacroExpand) that cause problems to some queries and set ServerOutput based on Debug settings

Which is the best way to have access and change them when needed?

Last edited by dcoun (2021-11-21 18:00:38)

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,659

Website

Re: Mormot2: Setting fDatabase.ResourceOptions for Firedac

I don't understand... IIRC fDatabase.ResourceOptions returns a class instance, so you can change the current DB options here.

dcoun

Member

From: Crete, Greece

Registered: 2020-02-18

Posts: 430

Re: Mormot2: Setting fDatabase.ResourceOptions for Firedac

I apologize. I was looking the TSqlDBConnection.
Migrated to ZEOS finally, to follow linux developments too

Last edited by dcoun (2021-11-22 10:25:32)

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,659

Website

Re: Mormot2: Setting fDatabase.ResourceOptions for Firedac

I have just created a new speCreated event which could be used to customize a database connection just after its creation, and before the connection.
It should work on all connection classes.

dcoun

Member

From: Crete, Greece

Registered: 2020-02-18

Posts: 430

Re: Mormot2: Setting fDatabase.ResourceOptions for Firedac

I have just created a new speCreated event which could be used to customize a database connection just after its creation, and before the connection.
It should work on all connection classes.

Thank you very much. That's helps a lot