Hello Clay,

> << You might want to check out our product "IB LogManager"
> which does that for you with a few clicks of the mouse.
>
> http://www.upscene.com/products/audit/index.htm
>
> With regards,
>
> Martijn Tonies>>
>
> Is there a way to keep a log of who views (without changing) specific
> records? In the hospital where I work, they want to be able to see who has
> viewed which patient's records...

Not with this product. IB LogManager relies on server side triggers to
record changes to records.

A SELECT doesn't generate a change, so you'll never know who views
what unless you build it in the client.

Another possibility would be, I guess, to create procedures like:

procedure GET_PATIENT_DETAILS ( PatientID: integer) returns ...
...
insert into patientlog( ... )
select * from patient where patientid = :patientid into ...

etc...

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com