[DUG] Data

[Mark Howard]

Eion

Sorry this is not a very technical response but.....
Is it always the same 300 records that are missing?
if so
finding out what is common with those 300 records and different from the records actually returned, may give you a clue.
Are they the last 300 (matching) records posted to the database?
Are they the last records returned (in the Dev system dataset)?

Mark

On Fri, 25 Nov 2005 16:54:26 +1300, Eion McIntosh (Christchurch) <e.mcIntosh at ppcs.co.nz> wrote:

> 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
>
>



-- 
Forest Production Systems Ltd
Creators of PSLog - A harvesting information system
www.pslog.co.nz
Skype: markhoward


-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.362 / Virus Database: 267.13.7/181 - Release Date: 24/11/2005