Devart Forums

trevor123

To get the behaviour I wanted, I added the following code to the AfterConnect even of the PgConnection

PgConnectionSOP.ExecSQL( 'SET app.current_tenant = ' + QuotedStr(tenant_id));

trevor123

I have a project that we have been using for a while, recently while making some changes I can no longer use the PgConnectDialog component

Delphi is switching PgDacFmx for PgDacVcl and refusing to compile

The only way I can solve it is by removing the PgConnectDialog component

Strange!

trevor123

So that all queries in the session run with app.tenet_id set to the connection value!

trevor123

Can I set a session variable when I connect?

Thanks

trevor123

Thank you, that works

trevor123

The following code works fine:

Code: Select all

SET app.current_tenant='8f8266ba-efdb-4fe3-ad16-fc4a295fe8a7';
SELECT * FROM tenant_user;

However, with :tid, I get Syntax Error at or near $1

Code: Select all

SET app.current_tenant=:tid;
SELECT * FROM tenant_user;

trevor123

I use CRBatchMove successfully in one part of my project, but in another place with similar (small tables) I get an error unless I set AbortOnError to False. The data looks ok, with this fix ... but it's strange that if works fine With AbortOnError set to True in another part of the project with very similar tables

I'm using Delphi XE7

Thanks

Devart Forums

Search found 7 matches

Re: Can you set a session variable with a query parameter?

PgConnectDialog in FMX project importing PgDacVcl

Re: Can you set a session variable with a query parameter?

Re: Can you set a session variable with a query parameter?

Re: Can you set a session variable with a query parameter?

Can you set a session variable with a query parameter?

CRBatchMove fails with '' not valid floating point