I have an FPMI application that runs a query and then loads screen components with that data. What I am getting is a descrepency in the date fields returned to the dataset. When I look at the dataset on my PC I get this test data, which is what is in the database:
"ProductionID","Production","Line","Shift","BPM","StartTime","EndTime","CaseCt","BoxChg","BoxMPC","ProdChg","ProdMPC","BottleChg","BottleMPC","Lab","Trials","TrialsTime","Minutes","Event"
"28","6-Pal, 2-24oz dep, 1-16oz dep","2","1","580","2008-09-09 06:01:00","2008-09-09 11:00:00","5500","2","10","0","20","0","90","10","0","0","33","test something"
"28","6-Pal, 2-24oz dep, 1-16oz dep","2","1","580","2008-09-09 06:01:00","2008-09-09 11:00:00","5500","2","10","0","20","0","90","10","0","0","13","test something else"
"28","6-Pal, 2-24oz dep, 1-16oz dep","2","1","580","2008-09-09 06:01:00","2008-09-09 11:00:00","5500","2","10","0","20","0","90","10","0","0","7","test third thing"
"29","6-Pal, 2-24oz dep, 1-16oz dep","2","2","580","2008-09-09 11:00:00","2008-09-09 18:11:00","8000","0","10","0","20","1","90","20","0","0","22","shift two testing"
"29","6-Pal, 2-24oz dep, 1-16oz dep","2","2","580","2008-09-09 11:00:00","2008-09-09 18:11:00","8000","0","10","0","20","1","90","20","0","0","12","shift two testing somethig else"
When I look at the dataset from a different PC I get the following dataset:
From PC 2
"ProductionID","Production","Line","Shift","BPM","StartTime","EndTime","CaseCt","BoxChg","BoxMPC","ProdChg","ProdMPC","BottleChg","BottleMPC","Lab","Trials","TrialsTime","Minutes","Event"
"28","6-Pal, 2-24oz dep, 1-16oz dep","2","1","580","2008-09-09 13:01:00","2008-09-09 18:00:00","5500","2","10","0","20","0","90","10","0","0","33","test something"
"28","6-Pal, 2-24oz dep, 1-16oz dep","2","1","580","2008-09-09 13:01:00","2008-09-09 18:00:00","5500","2","10","0","20","0","90","10","0","0","13","test something else"
"28","6-Pal, 2-24oz dep, 1-16oz dep","2","1","580","2008-09-09 13:01:00","2008-09-09 18:00:00","5500","2","10","0","20","0","90","10","0","0","7","test third thing"
"29","6-Pal, 2-24oz dep, 1-16oz dep","2","2","580","2008-09-09 18:00:00","2008-09-10 01:11:00","8000","0","10","0","20","1","90","20","0","0","22","shift two testing"
"29","6-Pal, 2-24oz dep, 1-16oz dep","2","2","580","2008-09-09 18:00:00","2008-09-10 01:11:00","8000","0","10","0","20","1","90","20","0","0","12","shift two testing somethig else"
They are both the same, except for the datetime fields. StartTime and EndTime.
These two field are datetime types in the database. I looked and
My query looks like this:
select a.*,b.Minutes,b.Event from dbo.tblpacklineproduction a left outer join dbo.tblPackLineDownEventLog b on b.ProductionID = a.ProductionID where Line = 1 and StartTime between '2008-09-09 0:00:00' and '2008-09-09 23:59:59'
Any ideas how to resolve my problem?