Page 1 of 1
Database Record Refresh
Posted: Thu Oct 16, 2003 4:38 am
by Ted_(Guest)
Hi,____ I have just noticed that R&R does not detect any recent changes in the master table while the report is currently running. It will just read the table again when there^s a change in the filter or when you close and open the report again. Is this so? If yes, is there a way to force R&R to read again the table to take up current table updates without closing the current report. Thanks.____Regards,____Ted____R&R version = 10+__Database = Oracle 7.3.4____
=> RE: Database Record Refresh
Posted: Thu Oct 16, 2003 12:23 pm
by kfleming
[updated:LAST EDITED ON Oct-16-03 AT 12:24 PM (EST)]In your RSW.INI file (in the windows directory)add a section called__DATABASE__(it will appear in brackets but the forum software strips them out of any messages...)__and in that section add a line that says:__AlwaysSelect=1____This will force the select to be re-evaluated every time you print or preview.____Kathleen__R&R Support
=> RE: Database Record Refresh
Posted: Thu Oct 16, 2003 2:05 pm
by RSeidman
Kathleen:____Will that solution work in RRW.ini as well.____Thanks,__Robert Seidman
==> RE: Database Record Refresh
Posted: Thu Oct 16, 2003 8:35 pm
by Ted_(Guest)
Hi Ms. Kathleen,____ Thank you for your reply. I tried it, but still the same, it won^t force R&R to re-evaluate. ____I tried to add these lines:__ [Database]__ AlwaysSelect=1__then these:__ [DATABASE]__ AlwaysSelect=1__then these:__ DATABASE__ AlwaysSelect=1__then these:__ database__ AlwaysSelect=1____Additional info:__ OS=Windows 2000 Service Pack 4__ R&R 10+ Build 10.1.002____I also searched for rsw.ini and it^s only 1 and in winnt folder.____Thanks and regards,____Ted____
===> RE: Database Record Refresh
Posted: Thu Oct 16, 2003 9:14 pm
by kfleming
Make sure that the line saying Database is surrounded in square brackets (just like Defaults is in the RSW.INI).____Kathleen__R&R Support
====> RE: Database Record Refresh
Posted: Tue Oct 21, 2003 12:20 am
by Ted_Velo_(Guest)
Hi Ms. Kathleen,____ Still having the same problem. Hope you can help me on this. Thanks.____Regards,____Ted__
=====> RE: Database Record Refresh
Posted: Tue Oct 21, 2003 6:17 am
by kfleming
The only other solution is to close and open the report each time.____Kathleen__R&R Support
======> RE: Database Record Refresh
Posted: Tue Oct 21, 2003 7:44 pm
by Ted_(Guest)
HI Ms. Kathleen,____Maybe you can consider this feature on your next R&R patch or upgrade.____Thanks.____Ted