Nero Shop smart, shop S-Mart Local time Today, 21:48 Joined Jan 8, 2002 Messages 217 Dec 10, 2002 #1 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 ???
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 ???
S shay Registered User. Local time Today, 21:48 Joined Apr 29, 2002 Messages 169 Dec 11, 2002 #2 You don't say how the export is triggered but if (dcount("*", YourQuery) > 0 then export is one way to do it. 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 Shop smart, shop S-Mart Local time Today, 21:48 Joined Jan 8, 2002 Messages 217 Dec 11, 2002 #3 Shay, Thanks for your reply. The query is triggered through code. I will give your suggestion a go. Thanks again
Shay, Thanks for your reply. The query is triggered through code. I will give your suggestion a go. Thanks again
