transaction log

[timmybuck]

Hi Guys,

i have a little task to do. I have a database with 4 tables. customer, booking, ticket and event.

I have to allow some users to browse the transaction log.

what is the transaction log ?

how do i go about making one ?

Is it a text file that the database writes too once transaction have been completed. I'm not sure.

Any Guidance would help

Cheers

[ednark]

what database do you use ? mysql, postgres, oracle?

also, different servers can be set to store or not store transaction files for each table... do you need to give access to the SQL transaction log itself, which may not be very non-sql-developer friendly

or do you want to make a seperate SQL table yourself and manually add rows to it for each transaction, that way you have direct controll of what each transactino looks like... the down side is you will probably not include enough information for you to use the transactions in order to recreate any lost data... but that is up to you