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 view the changes.
John
From: "Thomas Steinmaurer [email protected] [firebird-support]"
<[email protected]>
To: [email protected]
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.
#yiv6686612714 #yiv6686612714 -- #yiv6686612714ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6686612714
#yiv6686612714ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6686612714
#yiv6686612714ygrp-mkp #yiv6686612714hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv6686612714 #yiv6686612714ygrp-mkp #yiv6686612714ads
{margin-bottom:10px;}#yiv6686612714 #yiv6686612714ygrp-mkp .yiv6686612714ad
{padding:0 0;}#yiv6686612714 #yiv6686612714ygrp-mkp .yiv6686612714ad p
{margin:0;}#yiv6686612714 #yiv6686612714ygrp-mkp .yiv6686612714ad a
{color:#0000ff;text-decoration:none;}#yiv6686612714 #yiv6686612714ygrp-sponsor
#yiv6686612714ygrp-lc {font-family:Arial;}#yiv6686612714
#yiv6686612714ygrp-sponsor #yiv6686612714ygrp-lc #yiv6686612714hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6686612714
#yiv6686612714ygrp-sponsor #yiv6686612714ygrp-lc .yiv6686612714ad
{margin-bottom:10px;padding:0 0;}#yiv6686612714 #yiv6686612714actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6686612714
#yiv6686612714activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6686612714
#yiv6686612714activity span {font-weight:700;}#yiv6686612714
#yiv6686612714activity span:first-child
{text-transform:uppercase;}#yiv6686612714 #yiv6686612714activity span a
{color:#5085b6;text-decoration:none;}#yiv6686612714 #yiv6686612714activity span
span {color:#ff7900;}#yiv6686612714 #yiv6686612714activity span
.yiv6686612714underline {text-decoration:underline;}#yiv6686612714
.yiv6686612714attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv6686612714 .yiv6686612714attach div a
{text-decoration:none;}#yiv6686612714 .yiv6686612714attach img
{border:none;padding-right:5px;}#yiv6686612714 .yiv6686612714attach label
{display:block;margin-bottom:5px;}#yiv6686612714 .yiv6686612714attach label a
{text-decoration:none;}#yiv6686612714 blockquote {margin:0 0 0
4px;}#yiv6686612714 .yiv6686612714bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv6686612714
.yiv6686612714bold a {text-decoration:none;}#yiv6686612714 dd.yiv6686612714last
p a {font-family:Verdana;font-weight:700;}#yiv6686612714 dd.yiv6686612714last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6686612714
dd.yiv6686612714last p span.yiv6686612714yshortcuts
{margin-right:0;}#yiv6686612714 div.yiv6686612714attach-table div div a
{text-decoration:none;}#yiv6686612714 div.yiv6686612714attach-table
{width:400px;}#yiv6686612714 div.yiv6686612714file-title a, #yiv6686612714
div.yiv6686612714file-title a:active, #yiv6686612714
div.yiv6686612714file-title a:hover, #yiv6686612714 div.yiv6686612714file-title
a:visited {text-decoration:none;}#yiv6686612714 div.yiv6686612714photo-title a,
#yiv6686612714 div.yiv6686612714photo-title a:active, #yiv6686612714
div.yiv6686612714photo-title a:hover, #yiv6686612714
div.yiv6686612714photo-title a:visited {text-decoration:none;}#yiv6686612714
div#yiv6686612714ygrp-mlmsg #yiv6686612714ygrp-msg p a
span.yiv6686612714yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6686612714
.yiv6686612714green {color:#628c2a;}#yiv6686612714 .yiv6686612714MsoNormal
{margin:0 0 0 0;}#yiv6686612714 o {font-size:0;}#yiv6686612714
#yiv6686612714photos div {float:left;width:72px;}#yiv6686612714
#yiv6686612714photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv6686612714
#yiv6686612714photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6686612714
#yiv6686612714reco-category {font-size:77%;}#yiv6686612714
#yiv6686612714reco-desc {font-size:77%;}#yiv6686612714 .yiv6686612714replbq
{margin:4px;}#yiv6686612714 #yiv6686612714ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv6686612714 #yiv6686612714ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6686612714
#yiv6686612714ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6686612714
#yiv6686612714ygrp-mlmsg select, #yiv6686612714 input, #yiv6686612714 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv6686612714
#yiv6686612714ygrp-mlmsg pre, #yiv6686612714 code {font:115%
monospace;}#yiv6686612714 #yiv6686612714ygrp-mlmsg *
{line-height:1.22em;}#yiv6686612714 #yiv6686612714ygrp-mlmsg #yiv6686612714logo
{padding-bottom:10px;}#yiv6686612714 #yiv6686612714ygrp-msg p a
{font-family:Verdana;}#yiv6686612714 #yiv6686612714ygrp-msg
p#yiv6686612714attach-count span {color:#1E66AE;font-weight:700;}#yiv6686612714
#yiv6686612714ygrp-reco #yiv6686612714reco-head
{color:#ff7900;font-weight:700;}#yiv6686612714 #yiv6686612714ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv6686612714 #yiv6686612714ygrp-sponsor
#yiv6686612714ov li a {font-size:130%;text-decoration:none;}#yiv6686612714
#yiv6686612714ygrp-sponsor #yiv6686612714ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv6686612714
#yiv6686612714ygrp-sponsor #yiv6686612714ov ul {margin:0;padding:0 0 0
8px;}#yiv6686612714 #yiv6686612714ygrp-text
{font-family:Georgia;}#yiv6686612714 #yiv6686612714ygrp-text p {margin:0 0 1em
0;}#yiv6686612714 #yiv6686612714ygrp-text tt {font-size:120%;}#yiv6686612714
#yiv6686612714ygrp-vital ul li:last-child {border-right:none
!important;}#yiv6686612714
