StrataFrame Forum

DateTime2 support in DDT 1.6.7 beta?

http://forum.strataframe.net/Topic22855.aspx

By Edhy Rijo - 4/22/2009

Hi Trent,

I am creating a new table with a field type "DateTime2" and when deploying to SQL2008 I get an error when trying to create the xx_Insert store procedure:





X 4/22/2009 11:52:11 AM-> An error occurred while creating the stored procedure [dbo].[Inventory_Insert].

X 4/22/2009 11:52:11 AM-> SqlException

X 4/22/2009 11:52:11 AM-> Operand type clash: datetime2 is incompatible with int





What am I doing wrong?
By Trent L. Taylor - 4/22/2009

Nothing.  We will have to change the auto-generated sprocs.  I will add this to the list to check on the new data types when dynamically creating the SPROCS for new data types.
By Edhy Rijo - 4/22/2009

Trent L. Taylor (04/22/2009)
Nothing. We will have to change the auto-generated sprocs. I will add this to the list to check on the new data types when dynamically creating the SPROCS for new data types.


Great! thanks. I'll use "DateTime" instead until this is available.
By Keith Chisarik - 12/17/2009

Are the new datatypes supported yet? I am on 1.7.0.2 trying to use date and time data types and there are no default values available and I get the error above when trying to deploy.
By Trent L. Taylor - 12/18/2009

Hey Keith,



First, StrataFrame does support SQL Server 2008 and is predominately the only database that we use. Even if you do not use the new data types, SQL Server it is significantly faster than previous versions and supports a lot more within SPROCS, etc.



The DDT itself still needs to be updated to support some of the new data types. There have been more pressing things on the agenda so this has been pushed back until the first quarter as there is little to no demand for some of the new data types. There have been a few inquiries (as you can see via this post), but the SQL Server 2008 is supported for distribution on all data types except some of the newer data types, which are not an absolute necessity anyway...they just make a few things slightly easier.