View Full Version : Export Query


Nero
12-10-2002, 07:08 AM
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
12-11-2002, 03:36 AM
You don't say how the export is triggered but

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

is one way to do it.

shay :cool:

Nero
12-11-2002, 03:39 AM
Shay,
Thanks for your reply.
The query is triggered through code.
I will give your suggestion a go.

Thanks again