I am attempting to apply transaction processing to some tables in an app but find that it seems not to function correctly.

This is what is happening …….

The PROTECT.MFS is already added to a table (say table A) using TCL CONTROLON

Starting the transaction - TCL TRANSTION ON

Edit and save a row in table A and close the editor

(I Note a row is written to a table in the TRANSACT location. This appears to be the modified version of the table A row but has a "W" as the first character)

Open the row in table A with the editor again. No change appears - only the original row contents.

Commit the transaction TCL TRANSACTION COMMIT

(I Note that the row written to a table in the TRANSACT location has now gone)

Re-Open the record in table A . This is still the original. No changes have been applied.

Any ideas would be greatfully received

Thanks

I'm as puzzled as you. Normally I do transaction processing from within code itself and it has always seemed to work properly (but never on Native tables, only Bonded tables - notably SQL). I'll be the first to admit that I've not used it extensively since there originally were problems with some versions of Novell Netware. I've never tried the editor. The W-flag at the head of the record indicates that a Write is pending for the data. It can have other values during the process (I've seen an R indicating a rollback transaction if the I/O operation fails for some reason). I'll dig around a bit to see if I can find something else.

Don Miller

C3 Inc.

Don,Thanks for your response. If you think of anything I would interested in your comments. Writing to a record with code produces the same result!

Are you still having trouble with TP? We have used it extensively and are prepared to help. I don't recognise your problem but can do some research for you. I can also provide a summary of how it works. What version of AREV are you running?

Patrick

patrick@kennis.co.nz

View this thread on the forum...