Oliver:

I understand coming from VFP, as we were in that boat at one point ourselves.  In this particular example, you will want to use the Decimal data type in SQL Server.  This is the closest translation from the VFP Numeric.  An integer, in SQL and .NET, represents a whole number only, so no decimals.

There are some articles online about VFP to SQL data type translations.  Let me know if this doesn't get you going.

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
==============================================