|
I have setup a insert command that includes a dollar value like so:
VPODS.InsertCommandType = SqlDataSourceCommandType.Text
VPODS.InsertCommand = "INSERT INTO [VPO] ([OrderDate], [Project], [Supplies], [NoExceed])VALUES (@OrderDate, @Project, @Supplies, @NoExceed)"
VPODS.InsertParameters.Add("OrderDate", Now())
VPODS.InsertParameters.Add("Project", Project)
VPODS.InsertParameters.Add("Supplies", TypeCode.Boolean, Supplies)
VPODS.InsertParameters.Add("NoExceed", TypeCode.Decimal, NoExceed)
rowsAffected = VPODS.Insert()
It is posting to an Access DB and the NoExceed file is of DataType Dollar.
I get an error when I post and I know its the dollar field causing the problem. Got any suggestions?
Thanks for any help
|
|
|
|