Subject | Re: [firebird-support] Using variables in ESQL select statement |
---|---|
Author | Thomas Steinmaurer |
Post date | 2015-09-23T17:50:15Z |
Hi John,
as a bug then.
fine as well, as long as Data Execution Prevention isn't causing
troubles upon start up.
etc. Thus, once set up, all log code is stored inside the database in
triggers, so you don't have to have IB LogManager running in the background.
Log data is stored in regular tables inside the database, so you can
build a WebUI based front-end on top of that tables if you wish.
--
With regards,
Thomas Steinmaurer
http://www.upscene.com/
Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
> Thanks,ThomasAh, ok. Thought you gave the trial a try. I would have considered that
>
> That wasn't easily seem from the website - good to know.
as a bug then.
> Do you have itRunning fine on Windows 7, thus Windows 10 and Server 2012 should be
> available for Windows Server 2012, Server 2012 SP1, Server 2012 SP2, and
> Windows 10?
fine as well, as long as Data Execution Prevention isn't causing
troubles upon start up.
> We'd still like to look at it as part of our database (rather than anIB LogManager is just a front-end to define the log triggers, view data
> add on) as we have a web interface that is used to view the changes.
etc. Thus, once set up, all log code is stored inside the database in
triggers, so you don't have to have IB LogManager running in the background.
Log data is stored in regular tables inside the database, so you can
build a WebUI based front-end on top of that tables if you wish.
--
With regards,
Thomas Steinmaurer
http://www.upscene.com/
Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
> John
>
> ------------------------------------------------------------------------
> *From:* "Thomas Steinmaurer ts@... [firebird-support]"
> <firebird-support@yahoogroups.com>
> *To:* firebird-support@yahoogroups.com
> *Sent:* Wednesday, September 23, 2015 11:36 AM
> *Subject:* 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, 6, and 7).
>
> In case of an insert and update, IB LogManager only log old/new values
> for fields which are registered for logging and where the column value
> changed.
>
> --
> With regards,
> Thomas Steinmaurer
> http://www.upscene.com/
>
> Professional Tools and Services for Firebird
> FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
>
>
>
>
>