This is normal behaviour during write transactions. RUNMODAL normally demands some user action and since your write transaction isn't finished you can't use it, because there might be some table (page/record) locks and these will last until the user action is performed. Just think of, if your user starts the transaction and then goes away from his desk, his session might block all other user from working because his action won't finish until the runmodal form/report/dataport/page is closed.
Maybe you could use COMMIT (be very careful with it, you have to know what you do) beforehand or you need to redesign your solution. It depends on what you exactly want to do.
"Money is likewise the greatest chance and the greatest scourge of mankind."
Answers
Maybe you could use COMMIT (be very careful with it, you have to know what you do) beforehand or you need to redesign your solution. It depends on what you exactly want to do.