This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Hi, I just added a new property of a type TimeSpan in the LS designer. I clicked on "Updated Database.." and got an error: "-Can't translate data type 'TimeSpan' into SQL Server data type" How can I resolve this? I'm on SQL Server 2005
Thanks. |
|
|
|
|
I am currently on version 3.1.2423.16006 if that helps.. |
|
|
|
|
I just tried the latest release (19 June) version 3xxx but still getting the same result. |
|
|
|
|
It looks like we don't currently create columns from TimeSpan fields, I think because TimeSpans are represented as Int64 and this causes some ambiguity during subsequent database syncs. I'll try to get this resolved for you. |
|
|
|
|
BIGINT. LightSpeed has special handling for mapping BIGINT fields to TimeSpans. You can use the special SQL Server 2008 type as well, but BIGINT is more portable. |
|
|
|
|
I've committed an update for this (except for Oracle) and it will be in the next nightly build. Note that even on SQL Server 2008 it will create BIGINT columns rather than SQL time columns: if you want to use SQL time columns you will need to create a designer User Defined Type. |
|
|
|
|
We had a hiccup in the overnight build so this isn't up yet -- should be up tonight. |
|
|
|
