>>>I have a report that is based on a view that uses variables that are selected from a form. How do I return a message if the resultant view doesn't match the selection data that was entered in the form. In the old days, I could use:
>>>
>>>if _tally = 0
>>>
>>>after my select statement. But now I don't seem to have that kind of control.
>>>
>>>Thank you.
>>
>>How about RECCOUNT()
>>
>>Craig
>
>Perhaps I didn't make myself clear. Sorry. Yes, Reccount() would have worked in the 2.6 days after running a SELECT statement. However, this report uses a view in the data enviornment, so I (seemingly) have no control of the SQL, or cannot test the RECCOUNT() or _TALLY like I used to do. Therefore, is there anyway to send a message to a user telling them their selection criteria returned no records?

Hi,
RECCOUNT() should work fine. We have many,many,many parameterized views both in DE's from the designer and dynamic DE's from code and RECCOUNT let's us determine the results of the query. Us can also access the SQL in the view cursor and use CURSORGET/SETPROP to run the queries. (I think there is an article in Advisor on this one I'm working at home today and don't have my tricks binder here) Hope this helps.