Dave: Thank you very much for the utility. Last night, after trying a number of different things, I had written a utility similar to the one you sent; however, once I get to the browse screen (from within an application), I am still limited to one table/view and thus have the same problem...how do I get to the QUERY screen so I can modify the WHERE clause or add tables, etc.? It appears that the query utility has a lot more options in the DOS version. I know my DOS users would not be happy if their upgraded WINDOWS application does not have this functionality. Wouldn't it be nice if the WINDOWS version could have the option of going back to the QUERY screen via menu option or keystroke (like <CTRL.><F3> in DOS) included in the next online patch? And, if the PROMPT command would return? Razzak?
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:[EMAIL PROTECTED]]On Behalf Of David Blocker Sent: Friday, May 03, 2002 8:05 AM To: [EMAIL PROTECTED] Subject: Re: Using QUERY from within applications Javier Attached is a program I have written that allows users to query any database, any table or view. Re PROMPT: I suggest you contact RBTI directly and request that this feature be put back into the upcoming 7.0 release. As a teacher of newbees to R:Base, I also miss this feature. David Blocker ----- Original Message ----- From: "Javier Valencia" <[EMAIL PROTECTED]> To: "RBASE, LIST" <[EMAIL PROTECTED]> Sent: Thursday, May 02, 2002 10:27 PM Subject: Using QUERY from within applications > In RBASE for DOS I frequently use the command: > > QUERY * FROM table_name ORDER by column_name ASC > > from within an application. It brings the QUERY screen in which I can modify > the WHERE clause, add tables and so on and the move to the BROWSE screen > with the <F2> key... or else I use the command: > > QUERY * FROM table_name ORDER by column_name ASC EXECUTE > > Which brings the browse screen from which I can move back and forth to the > QUERY screen by using the <CTRL><F3> and <F2> keys; this allows the user to > modify the WHERE clause, add tables and save it as a view. > > I have tried to do the same in WINDOWS RBASE 6.5++ without luck. If I use > the QUERY command within an application, it flashes IN and OUT quickly and > continues to the next line of code. When I use the BROWSE command instead > of QUERY, I get the BROWSE screen but I am unable to get to the QUERY screen > to change the WHERE clause or add tables, etc and I am stuck with the > original WHERE clause as the BROWSE and QUERY icons are not visible for > within an application. I have tried all the key combinations to move between > the BROWSE and QUERY screens with no luck. > This feature was particularly popular and useful to users, as they were able > to create complex queries and save the results as views from within the > application without having to deal with the R Prompt. > Does anyone have a workaround to get the same functionality of DOS in the > Windows environment? > > Also, what ever happened to the PROMPT command? It as very easy to use a > command line such as: > > PROMPT SELECT > > from within an application and the system would guide the user through the > options and then run the command; again, a very useful command no longer > available in Windows. Any help in these areas would be greatly appreciated. > > 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 > > ================================================ > 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/
