Hi ,

I make upsizing from foxpro in 2009 to SqlServer, and during this date the field was in numeric 10,0 (for a floor an apartement)

Today we want to transform the database in the best quality , and in DDT we put the field Floor in "INT"

Unfortunately, all fields was in numeric, they don't cast in INT with DDT.

I don't know Why, may be DDT does not recognize the type numeric.

Have you an idea to apply the cast ?

thanks
Olivier,

==============================================
Asp.net C# - Strataframe - telerik
==============================================

Hello Michel,

We have find why the bomapper get int32 cause we have modify in DDT an numeric 10,0 to INT and
the boMapper get Int32 it's correct.

But DDT doesnt alter the column numeric to INT in Sqlserver.


Olivier

==============================================
Asp.net C# - Strataframe - telerik
==============================================

Hi Olivier,

I confirm your last post!

Having still Decimal(N,0) as datatype in SQL Server, I may see on my dev machine that BO mapper map it as decimal (fine, but will trigger an error on runtime), but that DDT on the same data map these columns as Int (I have NOT ask for any modification, just imported the data structure)

I will take a look at that.  Thanks for the heads up.  It has been a very long time since I have personally imported a VFP table.  So it is possible that there is something going on there.