[firebird-support] Re: RDB$Set_Context v GTT v Disk writes

Hi Louis, Thanks for your reply. My application architecture is the same as yours. The user logs onto the middle tier. A session key is generated and stored and all further use from that user is associated with that session key and user id. So we are both in the position of knowing exactly

RE: [firebird-support] Re: RDB$Set_Context v GTT v Disk writes

OK great minds think alike…! 8-[] Yes context variable is a way to do it as you suggest. My feeling is that the overhead of the context set would likely be small in comparison to all the other selects and updates that you would typically do within that request. So likely a workable

Re: [firebird-support] Using variables in ESQL select statement

Hi, > I had a look at IB LogManager. It doesn't quite do what I want. > > The requirement we have is to log only fields that change, not all > fields (which is what IB LogManager does). If I change fields 1, 4, and > 7 then those are the only fields I want logged (and not fields 1, 2, 3, > 4, 5,

Re: [firebird-support] Using variables in ESQL select statement

I had a look at IB LogManager. It doesn't quite do what I want. The requirement we have is to log only fields that change, not all fields (which is what IB LogManager does). If I change fields 1, 4, and 7 then those are the only fields I want logged (and not fields 1, 2, 3, 4, 5, 6, and 7). We

Re: [firebird-support] Using variables in ESQL select statement

Thanks,Thomas That wasn't easily seem from the website - good to know. Do you have it available for Windows Server 2012, Server 2012 SP1, Server 2012 SP2, and Windows 10? We'd still like to look at it as part of our database (rather than an add on) as we have a web interface that is used to

Re: [firebird-support] Using variables in ESQL select statement

Hi John, > Thanks,Thomas > > That wasn't easily seem from the website - good to know. Ah, ok. Thought you gave the trial a try. I would have considered that as a bug then. > Do you have it > available for Windows Server 2012, Server 2012 SP1, Server 2012 SP2, and > Windows 10? Running fine on

Re: [firebird-support] Securing database against corruption on systems that suddenly get turned off

On Mon, Sep 21, 2015 at 4:53 AM, Glenn Thomas Hvidsten g...@vensafe.no [firebird-support] wrote: > > > > We have FirebirdSQL (2.1) running on a client computer (Windows). This > client has some problems with his power grid which causes the PC to > suddenly and

RE: [firebird-support] Support for OS X 10.11 El Capitan

Hello Paul, I haven't actually confirmed that this is a SIP problem. I was suspecting this after googling a bit with log message received from installer logs. I have yet to disable SIP altogether, but will try this later today. Included is the installer log created by Firebird Installer. Sep

RE: [firebird-support] RDB$Set_Context v GTT v Disk writes

I use something that sounds similar. But why do you store users ids for a connection? The connection should be closed while the user is doing nothing. Only opened when db operations are being executed and close when done. This then takes advantage of connection pooling. Unclear how you use