StrataFrame Forum » StrataFrame Application Framework - V1 » Issues » DDT Database Import

DDT Database Import

Richard Keller — Wed, 25 Feb 2009 20:49:51 GMT

DDT Database Import converts Decimal(18,6) to Int.

Richard

RE: DDT Database Import

Govinda Berrio — Wed, 25 Feb 2009 20:49:51 GMT

I'm having this problem too. I have SF ver1.6.6.

Also, in the DDT Modify Table Structure screen, why isn't there a Numeric type in the Data Type drop down?

Thanks

RE: DDT Database Import

Trent L. Taylor — Fri, 02 Jan 2009 11:07:30 GMT

Larry,

Sorry for the delay here. Our responses are generally much quicker than this but we are not in the office this week. I will add this to the list and check into it next week. Thanks for the heads up! :)

RE: DDT Database Import

Larry McIntosh — Mon, 29 Dec 2008 21:32:29 GMT

I have found the DDT Import database structure converted all my numeric data types to "int". It imported decimal types properly but not numeric. For example, the DDT import for numeric(10,2) shows the data type as "Int" but the detail shows Size: 9, Precision: 10, Scale: 2 as for a numeric data type. The import was from an SQL 2005 database.

RE: DDT Database Import

Dustin Taylor — Tue, 02 Sep 2008 16:34:34 GMT

Bastian,

I've been trying to reproduce the issue you are describing but so far everything I've tried has come accross without issue. Creating and outlining a new table in the DDT with two decimal fields (one 18,4 and one 18,5) comes accross just fine after deployment.

Are you on the latest version of the framework? The 1.6.6 beta listed here is actually very stable (it will be released officially as soon as the documentation updates are completed.)

RE: DDT Database Import

Dustin Taylor — Tue, 02 Sep 2008 14:06:04 GMT

Sorry for the delay on this Bastian, we were all out of the office for labor day this weekend.

I believe we handled the above on an import a while back, but I'll need to reproduce the scenario you are describing on a deployment so we can work through it (if it still manifests.) I know you are in a rush for this so it is high on the priority list. I'll get back to you once I know more.

Thanks,

Dustin

RE: DDT Database Import

Bastian Töpfer — Thu, 28 Aug 2008 04:39:20 GMT

Oh, ... that was in the wrong topic.
I actually meant that this happens when I deploy a ddt package not when I import a database

RE: DDT Database Import

Bastian Töpfer — Thu, 28 Aug 2008 04:36:34 GMT

Hi,

any news about that? I have the same issue with decimal(18,4) and decimal(18,5)
This is very important and urgent to me. Planned to roll out to the first customer tomorrow and I cant if that doesnt work.

thanks for your help,

Bastian

RE: DDT Database Import

Trent L. Taylor — Wed, 21 Feb 2007 09:44:01 GMT

We'll look into this. Thanks.