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/ >
Anydb.rmd
Description: Binary data
