DateTime2 support in DDT 1.6.7 beta?


Author
Message
Edhy Rijo
E
StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)
Group: StrataFrame Users
Posts: 2.4K, Visits: 23K
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?

Edhy Rijo

Attachments
Reply
Edhy Rijo
E
StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)
Group: StrataFrame Users
Posts: 2.4K, Visits: 23K
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.

Edhy Rijo

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search