>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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement