Hello everyone ... again.

I have a new one. I have a VFP6 client/server application using SQL Server 2000. The weird situation is as follows: One runs two reports to check if they balance and they don't. Reboot the computer and rerun the reports and they match, with no change in the underlying data. Ths same SQL command, same parameters.

We're going to try simply exiting the application and restarting the next time this occurs. My question is ... during the life of the application the server connection maintains a single open channel. Might closing this channel between requests fix the problem of the server returning inaccurate requests?

Thanks again.