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
