"Paul Reeves"

> Jason Frey wrote:
> >
> > Is there any sort of trigger akin to AFTER FETCH, or some such, for when

a

> > person just views a record?
>
> No. In theory it could be implemented. However, would its benefit
> outweigh the cost of implementation and the probable drag on
> performance?

Other problems would be rolling after the select, this would make like the
fetches never occured.

More beneficial to me would be a switch you could throw giving the server
process the task of logging all DML issued into a RDB$ISSUED_DML table, it
would do this under its own transaction, thus not suffering from roll-back
issues. Even better for me would be to write these out to a textfile, like
the interbase.log.

To do the above at the moment I am toying with packet sniffing inbound
packets to the server (a techinique i have used with some success in the
past), and checking these out.

Both of these are for cross company performance tweaking and intrusion
alert.

I know, I know, get off your butt, Jason and write it then, as in my other
post, after I have finished this project, tidied my office, worked out how
to build FB, got to grips with C++ and become Harry Potter of the
conditional compile directive, I will undertake some of the changes Ihave
suggested over the last couple of years :-)

JAC.