>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..)

More info:

I have also just tried a global temporary table, after reading up about it here: http://www.oraclepassport.com/GTT.html

But that still does not allow me to update the table, if the stored procedures running in a read-only transaction ;-(

I have my temp table set to delete after commit.