[DUG] Data

[Eion McIntosh (Christchurch)]

Hi

We have two copies of a system. A development version and a live version. The live version is running under a terminalsservices session. 
A database query creates some total figures by month. Running the same query using the same data and the same version of the program between the development and live versions is returning different results. 
When running the version from the development PC the queries is returning the correct results even when pointing to the live database.
Running the live version, via the terminal services session, it appears to be not including about 300 records.
Both versions indicate they will be processing the same number of records, 1404, and the same procedure is being used everytime to start the queries. i.e. Once the program is started running the query is the first thing that occurs, so there can be no other background filtered or anything previous set up data which could be influencing the queries.

Any thoughts? 

Regards
Eion McIntosh
PPCS Ltd

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://ns3.123.co.nz/pipermail/delphi/attachments/20051125/091244dd/attachment.html