Bill, What happens when you use "AND yearDate IS NOT NULL", rather than the R:BASE 2.11 syntax of "EXIST"?
That operator was deprecated some time ago, in favor of SQL IS NOT NULL, and to avoid conflict with the different meaning of SQL EXIST, as in: AND EXIST (subquery) Bill On Mon, Oct 19, 2009 at 11:27 PM, Bill Niehaus <[email protected]>wrote: > 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 > > >
