RRWRUN w/o Closing Databases

[syntel]

(I tried to post a message earlier on this topic, but my post never showed up :(( )____ Anyway, when I try to run RRWRUN from inside my app, R&R complains that the Database is locked ! I open the .DBF files shared so that R&R should be able to use them without my cloing them first.____ So, how do I do that please.____ I use Version 8.1 and call RRWRUN from inside my app using either SWPRUNCMD(...) or WAITRUN(....)____ So, how can I force RRWRUN to run my report *without* closing the associated databases ??____TIA,____-Mel Smith__

[kfleming]

To allow database users to modify files in use by a Viewer report, include the switch /WY on your command line. ____Kathleen__R&R Support

[Mel_Smith_(Guest)]

Kathleen,____ My enviro is RRWRUN 8.1 (the 1026 one), Clipper 5.2e, the Fivewin windows library, and a ^super-browser^ for browing databases.____ // In my app I have a Browse with a ^Print^ button associated__ // I ^click^ on my print button and proceed to set up the print__ // operation ...__ // At this point I have closed all databases. But, I believe that__ // if I left them open (and shared), I wouldn^t get the fault I__ // describe below__ __ The command line in my code to get RR running____ cCMDLIN := "RRWRRWRUN REPORTS.DBF 1 /B /WY"__ nERROR := WAITRUN(cCMDLIN,1)____ As you can see I^m allowing write access when I start up rr. I also tried (with the same results) the Blinker ^swapper^ SWPRUNCMD()____ The symptom:____ When I click on the RR output selection ^Screen^ of the dialog, my appropriate report screen shows up and I can view the whole report. When I then click on the ^Abort^ button (that black square)to return to my app, the viewing screen shrinks to about half its full screen size, and is ^hung^. There is a lone little ^exit^ button on the top left of the menu bar, but it is not clickable. I then have to abort from the main browser screen.____ On the other hand, if I start by clicking RR^s ^Printer^ pushbutton (rather than start with ^Screen^), everything works normally, the report is printed, and I arrive back in my app and open my databases, and carry on with the ^browse^.____ I have tried leaving the databases open (& shared) but then RRWRUN won^t let me continue !! and return to the app with a complaint about how it can^t access the databases !!______Thanks for any further help you can offer.____-Mel Smith__

[kfleming]

R&R uses the same routines to open tables whether you are going to the screen or to the display so I think that it is unlikely that the problem is directly related to file access.____Does the problem occur with several or just one report?____Kathleen__R&R Support

[Mel_Smith_(Guest)]

Kathleen,____ So far, I^ve only got one report that re-acts this way (altho I of course I do have others).____ The other reports have no problem in returning from a call to the print function. However, they don^t use the same ^Browser^ !____ The essence of my problem is that when RRWRUN is aborted (thru the screen display of the report) and is returning thru the WaitRun()function, R&R fails to stop and totally hangs on the recovery to my app.____ I thought that if I could *leave my databases open* (and of course Shared), that maybe this problem would resolve itself.____ If you can find a way to leave my databases open, I *think* this may cure my problem.____ I^ve check that the report is set up to allow write, and I^ve placed the /WY in the command line, and RRW.INI says that Write is enabled.____Puzzle, puzzle ....____-Mel Smith__

[Mel_Smith_(Guest)]

To: Anyone ____ Help !!____ I *really* would like to *not* close my databases before executing RRWRUN (8.1)____ However, I^ve followed Kathleen^s suggestions (re: /WY) and I^ve re-checked the report (outside writing is allowed), etc, etc.____ If RRWRUN *really* allows databases to remain open during its running, WHY does it return to me saying it can^t access them ?? The databases (two of them) are opened in a Shared mode, and yet RRWRUN says it can^t access them.____ (I^ve posted the command line I use in previous posts to this thread. I^m stumped !!____ Please help.____-Mel Smith__