Hi Paul,

In this case I use SQL statements to create cursors. The source tables can be local VFP tables or remote (MSSQL Server) tables. I copy the data from the cursor to a local table. I may do more manipulations on the local table. Then I create my report based on the local table. I find it easier to create and test a report on a local table than a view.


Paul de Niverville



>Is there a good way to delete all the records in a view? I've got a view I use as a temporary place to modify/adjust information that ends up on a report. Once I'm done with the report, I need to delete all of the records so they don't affect the report the next time it's run.
>
> Actually, what I really need is a temporary cursor that is available/modifiable while the business object is instantiated and goes away when it's destroyed. It is, after all, only needed temporarily. Hmm...and it's definitely going to fail if more than one person tries to access it at the same time. Dang. Time to do some more thinking.