Out in the Cold !

[Mel_Smith_(Guest)]

>__>What if you don^t use tsbrowse but use tcbrowse instead, __>does it make a difference? ____ I don^t use TCBrowse (from Luis Krause) but use successfully TWBrowse with no incidents whatsoever ?? *It* works perfectly.____>Are the tables being opened in shared mode? What error msg __>are you getting when the program crashes in WaitRun? __>__>Randal ____ Yes, the tables are all opened SHARED (and before starting up waitrun(), I do a alias->(dbclosearea()) on each of the three dbfs.______The error message I^m getting is an attempt (*inside waitrun()*) to repaint my browse screen, and in this process (trying to re-establish my screen, it calls upon some methods in TSBROWSE (::paint, ::Skip, etc) which causes the crash because there is no database active.____ However, if the same sequence is used but I *print* instead, there is NO Error !!!____ The only thing different between the two sequences is that I *Move the Mouse* during screen viewing of the report. (whereas, with printing -- no mouse movement). Am I getting paranoid here !!____ BTW, in the last two days, I have had e-mail contact with some gurus (Patrick Mast, Luis Krause, and the author: Maunel Mercado). None of these gentlemen could come up with a definitive answer, and so I went into this new Class TSBrowse, found the point of failure, and returned out of the failing method (::paint) *IF* ALIAS() was Empty.____ The above gentlemen didn^t like this fix (it really *is* gross), but it is the only thing that gets me going, and back to my browse without crashing. They wanted me to check on the oBrw:cAlias being empty. That didn^t work either.____ (I even looked at the C-code for Waitrun() but was unable to understand it)____Thanks for your comments.____-Mel Smith____

[Randal_Ferguson_(Guest)]

Mel,____>I don^t use TCBrowse (from Luis Krause) but use __>successfully TWBrowse with no incidents whatsoever ?? *It* __>works perfectly. ____Yeah, I think the problem is in tsbrowse.____> Yes, the tables are all opened SHARED (and before __>starting up waitrun(), I do a alias->(dbclosearea()) on each __>of the three dbfs. ____You close the dbf^s before calling R&R? I thought you needed the tables to remain open and shared? I assume when the report goes to the preview tsbrowse will call the lost and get focus methods and if the tables are closed I can see why you^d get an error.____>The error message I^m getting is an attempt (*inside __>waitrun()*) to repaint my browse screen, and in this process __>(trying to re-establish my screen, it calls upon some __>methods in TSBROWSE (::paint, ::Skip, etc) which causes the __>crash because there is no database active. __>__> However, if the same sequence is used but I *print* __>instead, there is NO Error !!! __>__> The only thing different between the two sequences is __>that I *Move the Mouse* during screen viewing of the report. __>(whereas, with printing -- no mouse movement). Am I getting __>paranoid here !! __>__> BTW, in the last two days, I have had e-mail contact with __>some gurus (Patrick Mast, Luis Krause, and the author: __>Maunel Mercado). None of these gentlemen could come up with __>a definitive answer, and so I went into this new Class __>TSBrowse, found the point of failure, and returned out of __>the failing method (::paint) *IF* ALIAS() was Empty. __>__> The above gentlemen didn^t like this fix (it really *is* __>gross), but it is the only thing that gets me going, and __>back to my browse without crashing. They wanted me to check __>on the oBrw:cAlias being empty. That didn^t work either. __>__> (I even looked at the C-code for Waitrun() but was unable __>to understand it) ______I^m able to call an R&R report from tsbrowse without a problem using R&R 6.5.08 and 8.1____Randal__

[Mel_Smith_(Guest)]

__Randal says:____>You close the dbf^s before calling R&R? I thought you __>needed the tables to remain open and shared? I assume when __>the report goes to the preview tsbrowse will call the lost __>and get focus methods and if the tables are closed I can see __>why you^d get an error. ____ No, I do not *need* to have the tables to remain open and shared -- I^am forced to by RRWRUN !____ I am *forced* to Close the databases when I call RRWRUN *because* RRWRUN refuses to run my report because it ^Cannot Access etc, etc.....^ if the databases are left open !!____ If I *could* leave them open I sure as heck would do so ! (then I^m sure TSBrowse would work perfectly)____ Now, how do *you* get by with leaving them open ? That amazes me, and now I^m wondering if my Comix/Clipmore RDD is stopping me (somehow) from leaving them open.____ Again, I open all databases SHARED (but don^t use the clause ^READONLY^). Do you use ^readonly^______Thanks again for your questions and responses. I^m sure somehow I^ll find my problem. ____BTW, my enviro is win98se, blinker 5.1, comix/clipmore, and FW2.1c, and of course TsBrowse from Manuel Mercado. Now I^ve put a minor mod in the Class to enable me to skip out of the ::paint methods if Empty(Alias()). Of course, Luis, Patrick, and Manuel said I should use the instance vrbl empty(oBrw:cAlias) -- but if I empty ::cAlias *before* calling waitrun(), then waitrun doesn^t get back to my app but keeps spinning away in a hung state in the waitrun return sequence until you hit <Esc> then waitrun returns but the tsbrowse is (by then) ended too by the <Esc>.____-Mel Smith__

[Randal_Ferguson_(Guest)]

Mel,____> I am *forced* to Close the databases when I call RRWRUN __>*because* RRWRUN refuses to run my report because it __>^Cannot Access etc, etc.....^ if the databases are left open __>!! __> If I *could* leave them open I sure as heck would do so ! __>(then I^m sure TSBrowse would work perfectly) ____Ok, I understand and yes leaving them open would eliminate the problemw with tsbrowse.____> Now, how do *you* get by with leaving them open ? That __>amazes me, and now I^m wondering if my Comix/Clipmore RDD is __>stopping me (somehow) from leaving them open. ____I use Comix/Clipmore also.____> Again, I open all databases SHARED (but don^t use the __>clause ^READONLY^). Do you use ^readonly^ ____No.____>Thanks again for your questions and responses. I^m sure __>somehow I^ll find my problem. __>__>BTW, my enviro is win98se, blinker 5.1, comix/clipmore, and __>FW2.1c, and of course TsBrowse from Manuel Mercado. Now I^ve __>put a minor mod in the Class to enable me to skip out of the __>::paint methods if Empty(Alias()). Of course, Luis, __>Patrick, and Manuel said I should use the instance vrbl __>empty(oBrw:cAlias) -- but if I empty ::cAlias *before* __>calling waitrun(), then waitrun doesn^t get back to my app __>but keeps spinning away in a hung state in the waitrun __>return sequence until you hit <Esc> then waitrun returns but __>the tsbrowse is (by then) ended too by the <Esc>. ____I have the same environment. If the problem is only with one specific report you might consider creating a temp file and passing that to R&R instead of reporting on the active table. I would go back to leaving the tables open and finding the problem with R&R. Of course the waitrun/tsbrowse problem is not with R&R, the "Cannot Access" is somehow related to R&R. It may also have something to do with the master table and index (and/or tag order). If you want to send me some sample code I^d be happy to look at it for you.____Good luck,__Randal____

[Mel_Smith_(Guest)]

Randal,____ Because I created my first set of reports by ^converting^ them from a .RP1 library to a .RP5 library, I thought that maybe the conversion was causing me my problems. So, I created a whole new report (using the same Databases)and place in in STKLIST.RRW____ When I ran this report with open SHARED databases (and later with also READONLY), the result was identical: Cannot Access etc,etc____ So, I^ve changed the TSBROWSE Class (in the ::Paint() method) to stop the ^painting^ as follows:____ // check to bypass area paint routines____ *********** START OF CHANGES BY MEL SMITH MAR 13/02 ***__ // The following change forestalls from attempting to __ // repaint the screen and crash while trying to skip to__ // a non-existent record and get into a crash look__ IF EMPTY(ALIAS()) .OR. EMPTY(::cAlias)__ ::lRePaint := .F.__ ENDIF__ *********** END OF CHANGES BY MWS *********************____ If ! ::lRePaint__ Return 0__ EndIf____ etc, etc____ So, in the interests of non wasting your time (or mine), I^m not going to fuss with this problem any further, but simply make the above change is the TsBrowse Class and carry on. THanks for all your help !____ BTW, *my* RRWRUN executable is:____ RRWRUN.EXE 1,282,048 Aug 31/00 1:15p____ (maybe mine is different than other people^s ??)____-Mel Smith____

[Sergio_(Guest)]

When you^re app is running did you try openning your dbf with other viewers? If you cannot, then the problem may be related to your db engine where compatibility is not allowed. I had a simular case with ADS (Advantage Database Server), and solved it my turning db access to "Compatibility".____I used dbx.exe to test this.____Hope this helps.__Sergio