If my memory serves me correctly (an iffy proposition, that!), there used to be an undocumented variable that would show how R:Base was applying indexes to the different parts of the WHERE clause. In ORACLE it's called EXPLAIN PLAN. Perhaps MICRORIM_EXPLAIN_PLAN? Something similar? I guess, if it still exists, it could be RBTI_something.
Regards, Stephen Markson ForenSys The Forensic Systems Group www.ForenSys.ca <http://www.forensys.ca/> 416 512 6950 _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Downall Sent: November 5, 2008 3:19 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Is there a Query Analyzer Damon, R:BASE has a lot of features which provide much of the same functionality as SQL Query Analyzer, although because they are organized differently, you will have to learn how to use them. I don't remember which features were introduced back in 6.5, but that version had many of these features and 7.6 has them all, and probably more I haven't thought of. I'm not very familiar with MS Query Analyzer, but I have used it. * The Database Explorer is a visual interface to easily add or modify any type of database objects. * The editor (RBEDIT command) has a data dictionary accessible with the F3 key, which pastes what you choose into the editor. It's great for lists of columns in a SELECT command, etc. The 7.6 version is greatly enhanced from the 6.5 version, with many more types of objects you can pop-up and lookup. * In the editor, type the beginning of a command or function and press F5 and syntax template help is pasted at the cursor. * Also in the editor, Ctrl-F5 lets you pick a command from a menu for similar pasting. * In the editor, Shift-F3 pops up a context-sensitive hlep window. * The "unload" command and from the DB Explorer, the "unload..." context-menu choice generates SQL commands for copying tables, views, forms, reports, etc. * You can debug any command file with the SET TRACE command, which brings up a debugger window with the ability to walk through, set break points, and watch variable values. * There is a Query By Example tool the help build queries. * Similarly, there is a query builder you can access with the CHOOSE command: CHOOSE vWhereClause FROM #WHERE IN tablename Of course, if you love Query Analyzer, you should be able to use the Oterro ODBC driver to connect to the R:BASE database. Bill On Wed, Nov 5, 2008 at 12:58 PM, Gray, Damon <[EMAIL PROTECTED]> wrote: Greetings. I'm completely new to RBase (3 days) so please forgive my stunning ignorance. My company is still on 6.5, so my question relates directly to that. Is there any thing in RBase 6.5 that is analogous to the MS Query Analyzer or SQL Mgmt Studio? I'm guessing not, since I've not yet found it. Given the above, I'm looking at using MS Query to do this, but there is no RBase(ish) driver in my DSN list, yet the web site claims it was in place with version 6.1. Where do I get the ODBC driver that will allow me to query RBase through MS Query? Damon J. Gray Business System Services Anvil Corporation No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.175 / Virus Database: 270.8.6/1765 - Release Date: 11/5/2008 7:17 AM
