Toad World® Forums

Invalid cast error when editing table data

In Toad SQL Server Freeware I receive an error when editing table data. The column datatype is numeric(8,0). In the data editing grid I enter a 2 (or some other integer value). The error that I get is "Invalid cast from ‘System.String’ to ‘System.Data.SqlTypes.SqlDecimal’. This error doesn’t seem limited to just this one column. Editing data in other columns defined as numeric(8,0) raise the same error. Has anyone else seen this or have a workaround?

Hi, the same problem here!

Anyone with a solution?

This problem has been fixed in Toad SQL Server 6.5,thanks!