Troy, I have been using code that I developed similar to the one David Blocker posted a while back using the capabilities of the choose command. The only problem that I have is that I cannot go back and forth between the BROWSE and QUERY screens to gradually build the query from within an application. I am in complete agreement with you in regards to users having access to the R> Prompt; it has caused me nothing but grief in the past
Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln., Suite #14 Olathe, KS 66062-4571 (913)829-0888 (913)649-2904 FAX -----Original Message----- From: [EMAIL PROTECTED] [mailto:owner-rbase-l@;sonetmail.com]On Behalf Of Troy Sosamon Sent: Monday, November 11, 2002 12:41 PM To: [EMAIL PROTECTED] Subject: RE: Views and Layout Javier, In this case, I beleive your best option is to go the route that David Blocker suggested. He posted the code to use choose commands to build your query. I have been using this method in DOS for yours. It gives your users controlled access to being able to generate ad-hoc reports. The ad-hoc report write that I have written does not allow for multiple tables, but I have considered adding it. I always just build a view with the necessary tables and joins for any user that asks for something that is not alreayd there. I never liked the idea of givien the users to an R> prompt. As far as I am concrened the only command a user should ever type at the R> is EXIT. Troy Sosamon ===== Original Message from [EMAIL PROTECTED] at 11/11/02 10:58 am >Troy: >The users do not necessarily want to generate reports, just query the >database with the same functionality/flexibility that they had under DOS. >Many time is just a question of merging 3 or 4 tables and computing totals, >nothing that would require a report. Plus, the cost of Crystal reports for >a multiple user system does not come cheap. > >Javier Valencia, PE >President >Valencia Technology Group, L.L.C. >14315 S. Twilight Ln., Suite #14 >Olathe, KS 66062-4571 >(913)829-0888 >(913)649-2904 FAX > >-----Original Message----- >From: [EMAIL PROTECTED] [mailto:owner-rbase-l@;sonetmail.com]On >Behalf Of Troy Sosamon >Sent: Monday, November 11, 2002 11:47 AM >To: [EMAIL PROTECTED] >Subject: RE: Views and Layout > >Javier, > >Have you considered using Crystal Reports for your ad-hoc report writer? >Crystal connects to your R:base database via an ODBC connection, and then >you have all of it's capabilities. It is very easy for a user to set up a >multi table join and save the results to various formats. Crystal reports >also has graphing and drill down capabilities. > >Troy Sosamon > >===== Original Message from [EMAIL PROTECTED] at 11/10/02 1:25 am >>Alastair and Claudine: >>I concur wholly with your evaluation. The query functionality that we had >in DOS is not in >available in Windows. There is no simple way, from within an application, to >switch from the browser screen to the query screen like you could in DOS >(CTRL >>F3). In Windows, you have to build your query and once you execute the >command, there is no >way to get back to the QUERY screen to make changes such as add (or >subtract) tables and/or columns, create new links or change the selection >criteria. I >>always thought that this was one of the best features of R:Base, as it gave >the user unlimited >multi-table query capabilities from within an application, this in addition >to the problems that you pointed out. Mike Willochell at RBTI came up with >a >>kludged workaround, but is too complicated to put in an application. >>The other command that I used extensively in DOS was the PROMPT command; >with this command you >could simplify programming dramatically, it is too bad that it is not >available in Windows. If nothing else, it was an great teaching aid when >training >>new users. >>Last but definitely not least, unless you want to use Adobe Distiller, >there is no way to >store the results of a standard report to a file as you loose all >formatting; luckily, we will be getting this capability back in 7.0 >>Again, RBTI as done an excellent job in trying to accommodate all users >requests, and, who >knows, maybe 7.0 will give us this functionality back. All things >considered, I believe that switching to Windows was the right decision, >since the upgrade >>to 7.0 should be (hopefully) a snap. >> >>Javier Valencia, PE >>President >>Valencia Technology Group, L.L.C. >>14315 S. Twilight Ln., Suite #14 >>Olathe, KS 66062-4571 >>(913)829-0888 >>(913)649-2904 FAX >> >>-----Original Message----- >>From: [EMAIL PROTECTED] [mailto:owner-rbase-l@;sonetmail.com]On >Behalf Of Alastair >Burr >>Sent: Saturday, November 09, 2002 4:15 PM >>To: [EMAIL PROTECTED] >>Subject: Re: Views and Layout >> >>Claudine, >> >>Convert - yes, definitely! But I thought that everything in DOS was >supposed >>to available in Windows - that's partly what sold me and it's not true. >> >>That's NOT to say that RBWin is no good - there is a lot going for it and, >>on balance, I'd go for RBWin every time but I do miss the DOS browser, its >>simplicity and its ability to do what it says it does. >> >>I don't know if v7 will fix it but at the moment the screen layout is not >>saved properly and you can't - at least, I haven't found the way - to build >>a query like you could in DOS - it can be done but it's more complicated or >>involved. RBTI say that it works as it's meant to but my argument is that >>what it's meant to do is wrong (different) and not as good as it was in >>DOS!! But, as you see, there are ways around... >> >>Set soapbox off - for a while <g> and I'll try to stop swearing, I promise! >>Regards, >>Alastair. >> >> >> >>----- Original Message ----- >>From: "Claudine Robbins" <[EMAIL PROTECTED]> >>To: <[EMAIL PROTECTED]> >>Sent: Saturday, November 09, 2002 2:00 PM >>Subject: RE: Views and Layout >> >> >>Alastair, thanks for opening my eyes to the simplicity of the answer. One >>SELECT to create all the fields in the view, one BROWSE field-w to put them >>on the screen. Sorta like the Texas two-step. It works like a charm. >I'll >>still submit it to RDCC as an improvement to the view creation SELECT. Et >>plus de jurons en francais! (no more swearing in French). Going back to >>DOS?, I thought you were a convert to 7.0 like the rest of us <g>... >>~Claudine :) >> >>-----Original Message----- >>From: [EMAIL PROTECTED] [mailto:owner-rbase-l@;sonetmail.com] On >>Behalf Of Alastair Burr >>Sent: Saturday, November 09, 2002 2:52 AM >>To: [EMAIL PROTECTED] >>Subject: Re: Views and Layout >> >>Claudine, >> >>You might try going back to the DOS version because the Windows >>browser/editor isn't a patch on the older one. >> >>I've been trying for well over a year - ever since I upgraded to RBWIN - to >>get the missing functionality in the Windows browser that the DOS one had >>but swearing in English, pounding my head on the desk, or anything else has >>failed miserably. >> >>That said, can you not try something like this: >> >>browse col1=1=10, col2=1=20, col3=1=30 from tablename where idnum in >(select >>idnum from yourview) >> >>I hope that you have more luck than I've had, >>Regards, >>Alastair. >> >> >> >>----- Original Message ----- >>From: "Claudine Robbins" <[EMAIL PROTECTED]> >>To: <[EMAIL PROTECTED]> >>Sent: Friday, November 08, 2002 10:34 PM >>Subject: Views and Layout >> >> >>I have created a view which would fit perfectly in my browser screen if I >>was allowed to specify the width of each column as in a normal select >>(SELECT field1=10, field2=40, etc...). Using LAYOUT on, and formatting the >>browser columns apparently only works with tables (and then only when all >>fields in the table are included, although they can be squeezed to appear >>gone). Changing the default browser font, functions such as CTR and STRIM >>and pounding my hand on the desk while cussing in French don't work either! >>If no one else knows of a workaround, I think I'll submit this to RDCC as a >>desirable improvement in the next release. ~Claudine ☺ >> >>================================================ >>TO SEE MESSAGE POSTING GUIDELINES: >>Send a plain text email to [EMAIL PROTECTED] >>In the message body, put just two words: INTRO rbase-l >>================================================ >>TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >>In the message body, put just two words: UNSUBSCRIBE rbase-l >>================================================ >>TO SEARCH ARCHIVES: >>http://www.mail-archive.com/rbase-l%40sonetmail.com/ >> >>================================================ >>TO SEE MESSAGE POSTING GUIDELINES: >>Send a plain text email to [EMAIL PROTECTED] >>In the message body, put just two words: INTRO rbase-l >>================================================ >>TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >>In the message body, put just two words: UNSUBSCRIBE rbase-l >>================================================ >>TO SEARCH ARCHIVES: >>http://www.mail-archive.com/rbase-l%40sonetmail.com/ >> >>================================================ >>TO SEE MESSAGE POSTING GUIDELINES: >>Send a plain text email to [EMAIL PROTECTED] >>In the message body, put just two words: INTRO rbase-l >>================================================ >>TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >>In the message body, put just two words: UNSUBSCRIBE rbase-l >>================================================ >>TO SEARCH ARCHIVES: >>http://www.mail-archive.com/rbase-l%40sonetmail.com/ >> >>================================================ >>TO SEE MESSAGE POSTING GUIDELINES: >>Send a plain text email to [EMAIL PROTECTED] >>In the message body, put just two words: INTRO rbase-l >>================================================ >>TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >>In the message body, put just two words: UNSUBSCRIBE rbase-l >>================================================ >>TO SEARCH ARCHIVES: >>http://www.mail-archive.com/rbase-l%40sonetmail.com/ >> >>================================================ >>TO SEE MESSAGE POSTING GUIDELINES: >>Send a plain text email to [EMAIL PROTECTED] >>In the message body, put just two words: INTRO rbase-l >>================================================ >>TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >>In the message body, put just two words: UNSUBSCRIBE rbase-l >>================================================ >>TO SEARCH ARCHIVES: >>http://www.mail-archive.com/rbase-l%40sonetmail.com/ > >================================================ >TO SEE MESSAGE POSTING GUIDELINES: >Send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: INTRO rbase-l >================================================ >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: UNSUBSCRIBE rbase-l >================================================ >TO SEARCH ARCHIVES: >http://www.mail-archive.com/rbase-l%40sonetmail.com/ > >================================================ >TO SEE MESSAGE POSTING GUIDELINES: >Send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: INTRO rbase-l >================================================ >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: UNSUBSCRIBE rbase-l >================================================ >TO SEARCH ARCHIVES: >http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
