>Could you show your code here, and the exact value you wish to insert?
>
>>I have a price variable that is decimal and I am trying to insert it into a table whose price field is numeric 7,2 but I keep getting "Input string was not in a correct format". I have this app setup ASP using VFPOLEDB.
sure, it's done in VB.
Public zprice As Decimal
zprice = CDec(GridView2.Rows(0).Cells(2).Text)
SqlDataSource1.InsertCommand = "insert into trans2 (office,date,name,detail,noun,price) values ('" + zoffice + "', '" + zdate + "', '" + zname + "', '" + zdetail + "', '" + znoun + "', '" + zprice + "')"
To test my logic and syntax, I changed both var and table structure to char and it worked perfectly. But not with numeric. :-(
"Build a man a fire, and he's warm for a day.
Set a man on fire, and he's warm for the rest of his life."