BV Commerce Forum
»
BV Commerce Support
»
General Support
»
bvc_OrderPackage can not store reasonable TimeInTransit values
Rank: Member
Joined: 11/5/2003(UTC)
Posts: 2,136
Was thanked: 1 time(s) in 1 post(s)
|
The bvc_OrderPackage.TimeInTransit field is an int. The Package.Mapper converts TimeInTransit into ticks such as [2]2592000000000 for 3 days. This value is too big to store in an SQL Server int field.[/2] |
|
|
|
|
|
|
Rank: Member
Joined: 3/1/2006(UTC)
Posts: 1,142
|
We will have to change that into bigint for a future release. Would it help for us to provide you with sql to update the table for you? |
Justin Etheredge
Senior Software Engineer
BVSoftware |
|
|
|
|
|
Rank: Member
Joined: 11/5/2003(UTC)
Posts: 2,136
Was thanked: 1 time(s) in 1 post(s)
|
No thank you. I can wait for a future release. |
|
|
|
|
|
|
Rank: Member
Joined: 8/17/2006(UTC)
Posts: 681
|
Why don't you change the meaning of the TimeInTransit from ticks to something more reasonable like minutes or even hours?
There is no added value in making it Ticks except that you will get huge numbers all the time.
Corneliu. |
|
|
|
|
|
|
Rank: Member
Joined: 3/1/2006(UTC)
Posts: 1,142
|
Well, now that it is in Ticks we will most likely leave it that way since any values in that field would have to be converted and there is no guarantee that the conversion will work properly since it will just end up with a bunch of integers. For now we will most likely just update the field to be a bigint. |
Justin Etheredge
Senior Software Engineer
BVSoftware |
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.