Export Query (1 Viewer)

[Nero]

I have a query which exports data as a .txt file.
Is there a way of stopping the export if no data is returned from the query, something similar to the report On NoData event ???

 

[shay]

You don't say how the export is triggered but

if (dcount("*", YourQuery) > 0 then export

is one way to do it.

shay

 

[Nero]

Shay,
Thanks for your reply.
The query is triggered through code.
I will give your suggestion a go.

Thanks again