>Understand now. I suspect you have something like aggregate functions inside of the fields list, am I right? :-)
Yes, that is correct :)
>You can simulate NODATA by self manually using view parameters. Specify parameter values initially by such way that you know for sure that query would never return any record. Then do requery with another parameter that return you required records.
That's what I do now, but (I think) this is more time consuming than
'WHERE 0=1', since it immediatly sees that there are no matching records to come..
>I do not know. To test this, I need to have your query from your view. Can you send it?
It is just something like:
SELECT SUM( price ) AS tot_price, price_type
FROM pricelist
GROUP BY price_type
I have other where's in the list, but that's not relevant for this situation. :)
You should get the error: 'price_type is invalid in the select list, because......'
Tnx in advance.
Erik
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only