Thank you, Sergey. I didn't know of this clause. I will have to read the help of what it does. Hopefully the NOFILTER does not slower execution of the SQL command.
>Add NOFILTER clause to prevent creation of a filtered cursor.
>select * from mytable where mytable.myfld='ABC' into cursor MYCURS NOFILTER
>
>
>>I select a bunch of records into a cursor, as following:
>>
>>
>>select * from mytable where mytable.myfld='ABC' into cursor MYCURS
>>
>>
>>The message shows that, say 176 records selected. Yet when I do:
>>
>>? reccount("MYCURS")
>>
>>it returns total number of records in MYTABLE.
>>
>>What am I missing?
>>
>>Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham