Sami, Not possible as this is part of a complicated set of nested views. Since RBase does not presently support nested OUTER JOINS I have to resort to nested views that are each an OUTER JOIN.
I have a Master Member table (primary key MbrNumber) I have subsidary tables such a MbrCurHomeAdr, MbrCurWorkAdr, MbrCurEmailAdr etc. All of the subsidiary tables have a Foreign Key reference to the Master Member table. Since I don't have subsidiary records for some of the individual subsidiary tables when I want to combine say master with curhome and curwork address I need and OUTER JOIN between the Master and curhome as vuew and a second OUTER JOIN between the Master and curwork as a view or possibly an OUTER JOIN of the first view with the curwork. Since I have some 8 or 9 subsidiary table plus additional lookup tables for coded values you see how complex this could be in creating a final view. Would be so much easier it as with INNER JOINS we could nest OUTER JOINS and even better if we could also nest INNER and OUTER JOINS. Hopefully in version 9. Jim Bentley --- Sami Aaron <[EMAIL PROTECTED]> wrote: > Jim - > > One other solution would be to alter my original statement to > include "TEMP" > and just create the view on the fly then drop it immediately > after the > UNLOAD. > > Sami > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf > Of James > Bentley > Sent: Monday, March 31, 2008 7:17 PM > To: RBASE-L Mailing List > Subject: [RBASE-L] - Re: How do I make NULL truly NULL? > > Sami, > > Thanks for the suggestion. I am in the processing of revising > the VIEW by storing needed values in the database so I won't > need to futz with the QUOTE char. I am very wary of mixing > quote characters in the data base. Had real bad experience a > long time ago when RBase changed from the a default double > quote > to the SQL standard of single quote. > > Jim Bentley > --- Sami Aaron <[EMAIL PROTECTED]> wrote: > > > James - > > > > I like your ideas on enhancements to the UNLOAD command and > I > > hope you'll > > submit an enhancement request on the RDCC site. > > > > Regarding your creation of the view using the double-quotes, > > you can do it > > in R:BASE using a command file: > > > > First, create your view normally then UNLOAD STR FOR > viewname > > to a text > > file. > > > > Modify the text file to replace your single-quotes with > > double-quotes and > > add: > > > > DROP VIEW viewname > > SET QUOTES=NULL > > SET QUOTES=" > > CREATE VIEW viewname ... WHERE column = "value" > > SET QUOTES=NULL > > SET QUOTES=' > > > > RUN this text file to create your view. > > > > Then the view definition will be stored properly in the > > database. The only > > caveat is if you do a complete UNLOAD of the database you > need > > to be sure to > > run this external text file each time so the view is > recreated > > properly. > > You do NOT need to do this after normal RELOAD - just a full > > UNLOAD. > > > > I keep a special file with all views that have special > things > > like this and > > just routinely re-run it when needed. > > > > Sami > > > > ____________________________ > > Sami Aaron > > Software Management Specialists > > 913-915-1971 > > [EMAIL PROTECTED] > > > > > > > > > > -----Original Message----- > > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf > > Of James > > Bentley > > Sent: Monday, March 31, 2008 5:25 PM > > To: RBASE-L Mailing List > > Subject: [RBASE-L] - Re: How do I make NULL truly NULL? > > > > Rachel, > > Works properly for me in latest version 7.6 windows and 7.6 > > DOS. > > > > What I would like to see is an enhancement to the unload > > command > > to UNLOAD DATA FOR table/view as ASCII|CSV DELIMIT=char > > QUOTE=char NULL=ON|OFF > > > > the enhance would allow override the default DELIMITER > and/or > > QUOTE character or using NULL character just for this > > statement > > without having to issue SET COMMANDS. This would apply to > the > > output data NOT to any of the equivalent values used in > tables > > or views. I would be really nice if you could also define > by > > using (CHAR(##)) ON right side of Equal Sign; i.e. > > DELIMIT=(CHAR(44)) > > > > I recently had to do a workaround when I modified a view for > > data being exported Microsoft WORD. Word requires that you > > use > > " to enclose text that contains the DELIMIT comma that I > use. > > Prior to this I would SET NULL ' ' and SET QUOTES=". When I > > modified the view I put in text surrounded by SINGLE QUOTES. > > Needless to say VIEW now failed because the text was not > > surrounded by DOUBLE QUOTE character. I had to use the > SINGLE > > QUOTE and make the correction in a text editor external to > > RBase. > > > > Jim Bentley > > > > > > --- Rachael Malberg <[EMAIL PROTECTED]> > > wrote: > > > > > I seconded that. when issuing the following... > > > > > > set null '' > > > GATEWAY EXPORT CSV test.CSV + > > > SELECT * FROM ContactAddress OPTION COL_NAMES ON + > > > |QUALIFIER '|SEPARATOR ,|REC_SEP CRLF + > > > |SHOW_PROGRESS ON |ACTION OPENVIEW > > > > > > > > > then open the file in note pad, all my null fields = ' > ' > > > not ,, > > > > > > Dennis? or Steve? what is missing? > > > > > > ----- Original Message ----- > > > From: Matthew Burke > > > To: RBASE-L Mailing List > > > Sent: Monday, March 31, 2008 3:04 PM > > > Subject: [RBASE-L] - Re: How do I make NULL truly NULL? > > > > > > > > > Now I'm wondering if perhaps I need to export in another > > > way. I did >set null ' 'ß(there's a space between the > > single > > > quotes) > > > > > > > > > > > > And after doing that, using my previous example. > > > > > > > > > > > > > > > a > > > b > > > c > > > > > > 1 > > > text > > > -0- > > > text > > > > > > > > > > > > > > > .is now exporting to a csv as. > > > > > > > > > > > > "text"," "ß(four spaces between the quotes),"text" > > > > > > > > > > > > Matthew Burke > > > > > > Pioneer Bank - IT Department > > > > > > Computer Systems Technician > > > > > > 505-627-4415 > > > > > > > > > > > > This email contains PRIVILEGED AND CONFIDENTIAL > === message truncated === Jim Bentley American Celiac Society [EMAIL PROTECTED] tel: 1-504-737-3293 ____________________________________________________________________________________ You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access, No Cost. http://tc.deals.yahoo.com/tc/blockbuster/text5.com
