There is no 'top' word in the select statement therefore to have a 'order by' in that particular view statement should not be permitted. The answer was question specific so according...

In data region properties there is 'norows', you can write whatever message you want to send to your users in 'norows' when no data is returned to your query. That...