Home » Developer & Programmer » Reports & Discoverer » locking database while report is running
locking database while report is running [message #88377] Tue, 23 July 2002 23:18 Go to next message
candy cane
Messages: 1
Registered: July 2002
Junior Member
is there a way for us to prevent updates on the database when a report is run until the preview/printout of the report is generated? this would be to prevent any inconsistency on the data displayed in the report.... thanks! =)
Re: locking database while report is running [message #88381 is a reply to message #88377] Thu, 25 July 2002 05:37 Go to previous message
Geoffrey
Messages: 32
Registered: February 2002
Member
if you are using oracle you don't need to lock the database, oracle is read consitend.

but if you realy want to lock the database you can do it like this :

select
....
from
....
where
...
for update
Previous Topic: Reinstalling ORACLE 9i AS
Next Topic: Re: Problem with Report 6i during Printing i.e. in Compression
Goto Forum:
  


Current Time: Fri Mar 29 04:44:47 CDT 2024