Re: A subquery has returned not exactly one row.

sholmes@pacificnet.net wrote: : This is the result of calling a procedure from some code inside a New Era : application. The procedure is an aggregate select, that works just fine : from dbaccess. Am I overlooking some differences in using procedures : between SQL and 4GL? : By the way, I am the same Scott that was at netcom.com, for any of you that : remember me. Is there more than one row that satisfies the aggregate? For instance, if you select MAX(), is there > 1 row with that MAX value? I discovered that select UNIQUE MAX() is safer; if this solves your problem we're seeing performance differences between NE & ISQL (i.e.: a bug) ======================================================================= Dennis J. Pimple dennisp@informix.com Opinions expressed Principal Consultant -------------------- are mine, and do not Informix Software Inc Voice: 303-850-0210 necessarily reflect Denver Colorado USA Fax: 303-779-4025 those of my employer.