I updated the syntax, but it still says that no rows exist.
>>> Bill Downall <[email protected]> 10/20/2009 5:36 AM >>> 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
