I still have a book available that Bill Downall and I wrote a few years
back, "Advanced SQL Queries"
David
David Blocker
[EMAIL PROTECTED]
Telephone: 781-344-1920
Cell Phone: 339-206-0261
----- Original Message -----
From: "Emmitt Dove" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Sunday, April 06, 2008 8:13 AM
Subject: [RBASE-L] - Re: IF with SELECT
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.
--
No virus found in this incoming message.
Checked by AVG.
Version: 7.5.519 / Virus Database: 269.22.7/1361 - Release Date: 4/5/2008
7:53 AM
