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 > > >
