Skip to content
Advertisement

exception is happening and I don’t no why

I keep getting this exception. I want to insert using a query into a table called Toy.

It’s in this order as below:

Toy ID, Toy Name, age, price(as currency data type), color

Exception: invalid character value for cast

Advertisement

Answer

So I found out what was causing the Exception, ucanaccsess does not support a direct insertion of data,so you need to specify the column of the inserted data so the only change to my code will be :

User contributions licensed under: CC BY-SA
8 People found this is helpful
Advertisement