Data Environment question

[shannanl]

I am sending some information to a temporary table and then printing a report from that table. I then am deleting the data in that table, reinserting new data and printing again, etc, etc. My problem is that unless I unload the dataenvironment each time I get carry over data from the previous record. If I unload the dataenvironment and datareport after each record, I get an error saying invalid data source. Is there a good way to "flush" the dataenvironment and datareport after each recordset and get rid of this carry over data from the last record?

Thanks in advance.

 

[Masi]

Do you make a call to the Requery method too?

 

[shannanl]

I have tried to requery it like this statement just before my print statement:

DataEnvironment1.rsCommand1.Requery

I have also tried this code:

with dataenvironment1
if .connection2.state <> 0 then .connection2.close
do events
.connection2.open
end with

Neither seem to work