How to tell if any record in a cursor is not empty (or not null)

[Ruslan Zasukhin]

On 6/11/05 11:05 PM, "jda" <jda at his.com> wrote:

Hi Jon,

> I have a cursor with n records.

> I'd like to know if a particular field has data in any of these records.
> 
> Right now I'm looping through the cursor and testing that field in each
> iteration of the loop.
> 
> But I wonder if there is a simpler and better "SQL way" to do this?
> 
> (I know I can create a new cursor with a new search, but I'd rather avoid
> that).

Actually Vcusor API -- already not pure SQL way,
    but some kind of mix of SQL + API.

Answer on your question is -- There is NO other way.

What is you real task ?


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]