Subject Read-write transaction within a stored proc / optimisation
Author Maya Opperman

I am using Firebird 2.1.3.

I have set my reports (which rely of stored procedures for data) to use read-only transactions for speed.

I now have a situation, where I'd like my report's stored procedure to update a summary table, if the LastUpdated date in that table, is less than the latest SystemDate for that same entry in the transaction table.

Is there any way I can start a read-write transaction, within a stored procedure, that has been executed using a read-only transaction?

Or, is there perhaps a much better way of handling this problem? (If only views would only refresh if something had been posted to affect their data...but I guess that is asking too much..)


[Non-text portions of this message have been removed]