-
Posts: 4 Joined: Thu Dec 27, 2012 8:26 am
|
Posted: Fri Dec 28, 2012 11:22 pm
Thanks. I ran the dev1 program. Error still occurred. I also made the full integration instead of the quick just one and just finished and have similar error. On the quick integration ...
Query1 Reads SELECT a."zscTimestampStartCalcNum", ''||a."__900RANumber", a."_920DateOut", a."_925DateDueIn", a."_921TimeOut", a."_926TimeDueIn", ''||a."_915_200aUnitNumber" , 1, a."zscTimestampEndCalcNum" FROM "SampleEvents" a where a."__900RANumber" LIKE '-----' and a."zscTimestampStartCalcNum" Between 63492249600 and 63493545599 Union SELECT a."zscTimestampStartCalcNum", ''||a."__900RANumber", a."_920DateOut", a."_925DateDueIn", a."_921TimeOut", a."_926TimeDueIn", ''||a."_915_200aUnitNumber" , 1, a."zscTimestampEndCalcNum" FROM "SampleEvents" a where a."__900RANumber" LIKE '-----' and a."zscTimestampEndCalcNum" Between 63492249600 and 63493545599 Union SELECT a."zscTimestampStartCalcNum", ''||a."__900RANumber", a."_920DateOut", a."_925DateDueIn", a."_921TimeOut", a."_926TimeDueIn", ''||a."_915_200aUnitNumber" , 1, a."zscTimestampEndCalcNum" FROM "SampleEvents" a where a."__900RANumber" LIKE '-----' and a."zscTimestampStartCalcNum" < 63492249600 and a."zscTimestampEndCalcNum" > 63493545599 ORDER by 1
Query2 Reads SELECT a."zscTimestampStartCalcNum", ''||a."__900RANumber", a."_90100FKFullNamePhone", ''||a."_915_205Model" FROM "SampleEvents" a where a."__900RANumber" LIKE '-----' and a."zscTimestampStartCalcNum" Between 63492249600 and 63493545599 Union SELECT a."zscTimestampStartCalcNum", ''||a."__900RANumber", a."_90100FKFullNamePhone", ''||a."_915_205Model" FROM "SampleEvents" a where a."__900RANumber" LIKE '-----' and a."zscTimestampEndCalcNum" Between 63492249600 and 63493545599 Union SELECT a."zscTimestampStartCalcNum", ''||a."__900RANumber", a."_90100FKFullNamePhone", ''||a."_915_205Model" FROM "SampleEvents" a where a."__900RANumber" LIKE '-----' and a."zscTimestampStartCalcNum" < 63492249600 and a."zscTimestampEndCalcNum" > 63493545599 ORDER by 1
__________________________________ On the fully integrated one ...Query 1 Reads SELECT a."zscTimestampStartCalcNum", ''||a."__900RANumber", a."_920DateOut", a."_925DateDueIn", a."_921TimeOut", a."_926TimeDueIn", ''||a."_915_200aUnitNumber" , 1, a."zscTimestampEndCalcNum" FROM "SampleEvents" a where a."zscTimestampStartCalcNum" Between and Union SELECT a."zscTimestampStartCalcNum", ''||a."__900RANumber", a."_920DateOut", a."_925DateDueIn", a."_921TimeOut", a."_926TimeDueIn", ''||a."_915_200aUnitNumber" , 1, a."zscTimestampEndCalcNum" FROM "SampleEvents" a where a."zscTimestampEndCalcNum" Between and Union SELECT a."zscTimestampStartCalcNum", ''||a."__900RANumber", a."_920DateOut", a."_925DateDueIn", a."_921TimeOut", a."_926TimeDueIn", ''||a."_915_200aUnitNumber" , 1, a."zscTimestampEndCalcNum" FROM "SampleEvents" a where a."zscTimestampStartCalcNum" < and a."zscTimestampEndCalcNum" > Union SELECT b."zscTimestampStartCalcNum", ''||b."id", b."DateStart", b."DateEnd", b."TimeStart", b."TimeEnd", ''||b."Resource" , 2, b."zscTimestampEndCalcNum" FROM "ToDoList" b where b."zscTimestampStartCalcNum" Between and Union SELECT b."zscTimestampStartCalcNum", ''||b."id", b."DateStart", b."DateEnd", b."TimeStart", b."TimeEnd", ''||b."Resource" , 2, b."zscTimestampEndCalcNum" FROM "ToDoList" b where b."zscTimestampEndCalcNum" Between and Union SELECT b."zscTimestampStartCalcNum", ''||b."id", b."DateStart", b."DateEnd", b."TimeStart", b."TimeEnd", ''||b."Resource" , 2, b."zscTimestampEndCalcNum" FROM "ToDoList" b where b."zscTimestampStartCalcNum" < and b."zscTimestampEndCalcNum" > ORDER by 1
Query2 Reads SELECT a."zscTimestampStartCalcNum", ''||a."__900RANumber", a."_90100FKFullNamePhone", ''||a."_915_205Model" FROM "SampleEvents" a where a."zscTimestampStartCalcNum" Between and Union SELECT a."zscTimestampStartCalcNum", ''||a."__900RANumber", a."_90100FKFullNamePhone", ''||a."_915_205Model" FROM "SampleEvents" a where a."zscTimestampEndCalcNum" Between and Union SELECT a."zscTimestampStartCalcNum", ''||a."__900RANumber", a."_90100FKFullNamePhone", ''||a."_915_205Model" FROM "SampleEvents" a where a."zscTimestampStartCalcNum" < and a."zscTimestampEndCalcNum" > Union SELECT b."zscTimestampStartCalcNum", ''||b."id", b."zscToDoSummaryCalc", ''||b."Status" FROM "ToDoList" b where b."zscTimestampStartCalcNum" Between and Union SELECT b."zscTimestampStartCalcNum", ''||b."id", b."zscToDoSummaryCalc", ''||b."Status" FROM "ToDoList" b where b."zscTimestampEndCalcNum" Between and Union SELECT b."zscTimestampStartCalcNum", ''||b."id", b."zscToDoSummaryCalc", ''||b."Status" FROM "ToDoList" b where b."zscTimestampStartCalcNum" < and b."zscTimestampEndCalcNum" > ORDER by 1
|