Subject Re: requery problem (semi reason) From Mervyn Bick <invalid@invalid.invalid> Date Tue, 21 Jul 2020 17:02:44 +0200 Newsgroups dbase.getting-started On 2020-07-21 06:58, Tony H wrote: > I have written the following code and need to "empty Table" after the print is finished - The code included does it all except emptying the table for next printing session. A couple of trial coding at the end but I get errors. I need to change from "query" to exclusive use I think, but not sure how ?? Some more thoughts on this. There are some cases (very few!) where creating a temporary table, from which a report is printed, is unavoidable.  In most cases it is possible to access the required data direct from the application's tables.  This is true whether using the old XDML commands to access the tables or the new OODML commands. How do you build batch.dbf? What table(s) does the actual data saved in batch.dbf come from? How do you decide which data to transfer from the application's tables to batch.dbf? The report you generate from batch.dbf is so straightforward that it is ideal to introduce you to the dBASE report designer.  If you attach a sample batch.dbf to a message I'd be happy to show you just how easy it is. Mervyn