why this gonna happened on my query and i use ms access for my database and vb.net this is the problem every time i add an equal sign on my query will be error when i erase the equal sign it works but i want to execute my query with an greater than equal can any one know how to fixed the issue thanks in advanced. this is my query w/out =sign Dim cmd As OleDbCommand = New OleDbCommand(UPDATE Medicine_inventory SET [Stock_on_hand] = Stock_on_hand - & dgmed.Rows(y).Cells(1).Value & where Name_of_Medicine like & dgmed.Rows(y).Cells(0).Value & and Stock_on_hand > & dgmed.Rows(y).Cells(1).Value & , con) with =sign Dim cmd As OleDbCommand = New OleDbCommand(UPDATE Medicine_inventory SET [Stock_on_hand] = Stock_on_hand - & dgmed.Rows(y).Cells(1).Value & where Name_of_Medicine like & dgmed.Rows(y).Cells(0).Value & and Stock_on_hand > = & dgmed.Rows(y).Cells(1).Value & , con)
Posted on: Tue, 14 Oct 2014 02:51:06 +0000
Trending Topics
Recently Viewed Topics
© 2015