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

jda jda at his.com
Sat Jun 11 16:05:12 CDT 2005


Hi all,

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).

Thanks,

Jon


More information about the Valentina mailing list