locked
error RRS feed

  • Question

  • 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 :)
    Sunday, January 18, 2009 10:56 AM

All replies

  • 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.
    Thursday, January 29, 2009 5:37 AM