EXISTS is an obsolete command - use IS NOT NULL instead. Regards, Alastair.
----- Original Message ----- From: Bill Niehaus To: RBASE-L Mailing List Sent: Tuesday, October 20, 2009 4:27 AM Subject: [RBASE-L] - Counting rows in view in Rbase 9 I am trying to determine how many rows are in a view. (This is part of some code that seemed to work ok in version 8.) SELECT COUNT(*) INTO vLines INDIC ivLines FROM viewName WHERE copynbr = 1 AND yeardate EXIST copynbr is an integer from 1 to 30. yeardate is a date column. This command fails in version 9 and gives me error 2059. It works if I only have one condition. I tried to verify that the conditions do exist by using a two condition browse command, but it also fails. browse all from viewName where copynbr = 1 and yeardate exist If I browse all in the view, there are rows that certainly appear to meet both of the criteria. Am I over looking something with using browse or select with a view? Thanks. Bill Niehaus >>> "MikeB" <[email protected]> 10/19/2009 12:17 PM >>> If you care to post the number, I will pass it on (and on and on) for you.... ;-) ----- Original Message ----- From: "Bill Niehaus" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Monday, October 19, 2009 11:31 AM Subject: [RBASE-L] - Re: 2009 Annual R:BASE Conference Package Please sign me up for one of the conference packages. Shirt size is extra large and I would like to charge it to a Visa card. Not sure if you have that number on file. Bill >>> John Minyo II <[email protected]> 10/19/2009 9:21 AM >>> To R:BASE Community: For those of you who could not attend the breakthrough 2009 Annual R:BASE Conference in Pittsburgh, you may now acquire the Conference memorabilia along with the technical presentation materials, product showcase, and sample databases and applications. For complete details: http://www.rbase.com/cp Please also visit the above URL to locate links to the 2009 Annual R:BASE Conference blog and photos. Very Best Regards, Best regards, John Minyo II R:BASE Technologies, Inc. Customer Service http://www.rbase.com [email protected] Phone: 1+724.733.0053 ------------------------------------------------------------------------------ No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.422 / Virus Database: 270.14.21/2445 - Release Date: 10/19/09 06:40:00
