Not work correctly
-
Hi I try to update a value inside a table (ExTable01) but updated value is not true.Please help. When I apply update Saved wrong value is 891257536,00 (Column type real False ) but True value is 891257560 ( --> 97352 * 9155 = 891257560 ) Best regards
-
Hi I try to update a value inside a table (ExTable01) but updated value is not true.Please help. When I apply update Saved wrong value is 891257536,00 (Column type real False ) but True value is 891257560 ( --> 97352 * 9155 = 891257560 ) Best regards
-
Which database system? And how are you updating? If through an update statement, where is it?
MSSQL-TSQL From Calucaltor TRUE RESULT : 164016 * 9155 = 1501566480 I check form profiler: Update TestTable Set Con=@Con, Ust=@Ust, En =@En,Tem=@Tem, Where ID=@ID',N'@Con decimal(6,0),@Ust decimal(4,0),@En decimal(10,0),@Tem decimal(3,2), ID bigint',@Con=164016,@Ust=9155,@En=1501566480,@Tem=7.50,@ID=95452 Finally I check database to see value: select str(En,25,5) as ToSeevalue, En, Con , Ust,* from TestTable where ID = 95452 -- REsult (WRONG OUTCOME): ToSeevalue: 1501566464.00000 En: 1,501566E+09 Con: 164016 Ust: 9155
-
MSSQL-TSQL From Calucaltor TRUE RESULT : 164016 * 9155 = 1501566480 I check form profiler: Update TestTable Set Con=@Con, Ust=@Ust, En =@En,Tem=@Tem, Where ID=@ID',N'@Con decimal(6,0),@Ust decimal(4,0),@En decimal(10,0),@Tem decimal(3,2), ID bigint',@Con=164016,@Ust=9155,@En=1501566480,@Tem=7.50,@ID=95452 Finally I check database to see value: select str(En,25,5) as ToSeevalue, En, Con , Ust,* from TestTable where ID = 95452 -- REsult (WRONG OUTCOME): ToSeevalue: 1501566464.00000 En: 1,501566E+09 Con: 164016 Ust: 9155
-
MSSQL-TSQL From Calucaltor TRUE RESULT : 164016 * 9155 = 1501566480 I check form profiler: Update TestTable Set Con=@Con, Ust=@Ust, En =@En,Tem=@Tem, Where ID=@ID',N'@Con decimal(6,0),@Ust decimal(4,0),@En decimal(10,0),@Tem decimal(3,2), ID bigint',@Con=164016,@Ust=9155,@En=1501566480,@Tem=7.50,@ID=95452 Finally I check database to see value: select str(En,25,5) as ToSeevalue, En, Con , Ust,* from TestTable where ID = 95452 -- REsult (WRONG OUTCOME): ToSeevalue: 1501566464.00000 En: 1,501566E+09 Con: 164016 Ust: 9155
-
MSSQL-TSQL From Calucaltor TRUE RESULT : 164016 * 9155 = 1501566480 I check form profiler: Update TestTable Set Con=@Con, Ust=@Ust, En =@En,Tem=@Tem, Where ID=@ID',N'@Con decimal(6,0),@Ust decimal(4,0),@En decimal(10,0),@Tem decimal(3,2), ID bigint',@Con=164016,@Ust=9155,@En=1501566480,@Tem=7.50,@ID=95452 Finally I check database to see value: select str(En,25,5) as ToSeevalue, En, Con , Ust,* from TestTable where ID = 95452 -- REsult (WRONG OUTCOME): ToSeevalue: 1501566464.00000 En: 1,501566E+09 Con: 164016 Ust: 9155
Also what types are the following? Con Ust En
Every day, thousands of innocent plants are killed by vegetarians. Help end the violence EAT BACON
-
MSSQL-TSQL From Calucaltor TRUE RESULT : 164016 * 9155 = 1501566480 I check form profiler: Update TestTable Set Con=@Con, Ust=@Ust, En =@En,Tem=@Tem, Where ID=@ID',N'@Con decimal(6,0),@Ust decimal(4,0),@En decimal(10,0),@Tem decimal(3,2), ID bigint',@Con=164016,@Ust=9155,@En=1501566480,@Tem=7.50,@ID=95452 Finally I check database to see value: select str(En,25,5) as ToSeevalue, En, Con , Ust,* from TestTable where ID = 95452 -- REsult (WRONG OUTCOME): ToSeevalue: 1501566464.00000 En: 1,501566E+09 Con: 164016 Ust: 9155
I found a solution .Column data type was real I changed it.Now it's decimal (38,4)
-
I found a solution .Column data type was real I changed it.Now it's decimal (38,4)