sysop@stech.UUCP (Jan Harrington) (01/20/88)
Well, R:base for DOS appeared via UPS person yesterday. The first thing I did was grab the user's manual out of the box and look at what they'd done to the SELECT command. Why? One of my greatest problems with the package (and I really do like it) was that SELECT could only query a single table. I had hoped, with the advertising of SQL, that SELECT would be a SQL SELECT and that it would allow multiple table queries. Unfortunately, that is not the case. Thought Microrim has added SELECT DISTINCT and grouping queries, each still works off a single table or view. I'm very disappointed. However --- (and this is a big however) --- a view can be created which _does_ query multiple tables. I'm very surprised that the CREATE VIEW statement allows a SQL-like SELECT (e.g., multiple tables) but the stand- alone SELECT doesn't. Anybody from Microrim out there? How 'cum, guys? If it can be done with a view, why not with a SELECT? Jan Harrington, sysop Scholastech Telecommunications ihnp4!husc6!amcad!stech!sysop or allegra!stech!sysop ******************************************************************************** Miscellaneous profundity: "No matter where you go, there you are." Buckaroo Banzai ********************************************************************************
UH2@PSUVM.BITNET (Lee Sailer) (01/21/88)
In article <417@stech.UUCP>, sysop@stech.UUCP (Jan Harrington) says: > >However --- (and this is a big however) --- a view can be created which >_does_ query multiple tables. I'm very surprised that the CREATE VIEW >statement allows a SQL-like SELECT (e.g., multiple tables) but the stand- >alone SELECT doesn't. Anybody from Microrim out there? How 'cum, guys? >If it can be done with a view, why not with a SELECT? 1. I'm surpised too. The whole point of the new RBASE was to add SQL. If the new SELECT cannot access multiple tables then I will lose all respect for the marketing people at MicroRim 8-) 2. Even in RBASE SV, the VIEW command could do a natural join across multiple tables. Does the new rBase add anything to that? 3. I considered getting the new rBase, but finally decided to invoke the "never buy anything less than a year old or you'll be the one to find all the bugs" proverb. (I still find the bugs in SV1.0 8-) lee
wozniak@utkux1.utk.edu (Bryon Lape) (10/14/89)
I have several questions about R:BASE for Dos. First, how does one keep the keyboard from enterferring (sp?) with the application file's execution? Second, does anyone know the file structure of the three data base files used by R:BASE for the storing of the actual data base? I know that there are several books of file formats, but I have yet to find one that says anything about R:Base. Thirdly, is there a programme (public domain if possilbe) that converts an R:Base application file into a C programme that can be compiled? If I knoew the fiel format for the data files I could do this, but I would rather not. -bryon-