Jons, I second Emmitt's recomentation of Joe Celko's SQL books.
Joe Celko joined the ANSI X3H2 Database Standards Committee in 1987 and helped write the ANSI/ISO SQL-89 and SQL-92 standards. ... Visit his site www.celko.com/ --- Emmitt Dove <[EMAIL PROTECTED]> wrote: > Joe Celko has some good books on SQL. > > Emmitt Dove > Manager, DairyPak Business Systems > Evergreen Packaging, Inc. > [EMAIL PROTECTED] > [EMAIL PROTECTED] > (203) 643-8022 > > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf > Of John > Docherty > Sent: Saturday, April 05, 2008 9:37 PM > To: RBASE-L Mailing List > Subject: [RBASE-L] - Re: IF with SELECT > > Thanks Emmitt - that sorts that out. > > I was looking at purchasing an SQL reference book a while ago > but wasn't > sure which to choose, so ended up with nothing. Do you, or > anyone else, have > any suggestions in that regard ? > > Regards, > > John Docherty > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf > Of Emmitt Dove > Sent: Sunday, 6 April 2008 1:25 p.m. > To: RBASE-L Mailing List > Subject: [RBASE-L] - Re: IF with SELECT > > Since the IF .. THEN construct isn't part of SQL, a SQL SELECT > is out of > place there. > > Emmitt Dove > Manager, DairyPak Business Systems > Evergreen Packaging, Inc. > [EMAIL PROTECTED] > [EMAIL PROTECTED] > (203) 643-8022 > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf > Of John > Docherty > Sent: Saturday, April 05, 2008 9:03 PM > To: RBASE-L Mailing List > Subject: [RBASE-L] - Re: IF with SELECT > > Albert, > > Thanks for your reply. I had changed my routine as you have > suggested, but > it would be handy if you could do it the other way ? > > Regards, > > John Docherty > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf > Of Albert Berry > Sent: Sunday, 6 April 2008 9:22 a.m. > To: RBASE-L Mailing List > Subject: [RBASE-L] - Re: IF with SELECT > > John, you can > SELECT COUNT(*) INTO vsCount FROM sections WHERE sno = .vsno > IF vsCount > 0 THEN > -- whatever > ENDIF > > AFIK the IF statement does not allow embedded SELECT clauses > in R:Base > > > John Docherty wrote: > > I am wanting to base an IF statement on the existence of a > number in a > > table, > > however I receive the following error with my attempt, which > is > > > > IF vsnew IN (SELECT secno FROM sections WHERE sno=.vsno) > THEN . > > > > -ERROR- Sub-SELECTs are not supported by this command. > (2310) > > > > I was wondering if the only way of achieving this to do a > SELECT INTO (or > > similar) to determine if any values exist that meet the > criterion or, is > > this possible, but my statement is incorrect ? > > > > Any suggestions would be much appreciated. > > > > > > > > > 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
