User1771087955 posted
i'm making an insert value query to add a new product to my product list in the query builder i have ARWNST ( the profict in procent) and i say new value: txtWinst ( here the procent needs to be entered e.g : 20 ) the error it says when i try to type txtWinst
is : literal of the correct data type required ... now i don't understand this error i tried txtwinst.text or something didn't work either ... need your help fast. thank you in advance. Erik P.S the connection worked in the meanwhile :)
User1311465606 posted
data type of that field in database may not be varchar. So you need to convert the text to integer or double using 'ConvertTo'. Then submit that value to database. I think this will work.
