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