Printable View
my problem is this,i am using a barcode reader to enter data in msflexgrid,then my quantity column,automatically add 1 if it has the same item to enter.if a user made a mistake like for example,entering item more than the order of customer.like if a customer order only 3 same item then the user entered 5,how can i subtract that existing quantity of item in msflexgrid quantity column and update the database..
Create a procedure that allows the user to correct the value.
It seems obvious that the writing of the data in the database should only occur when the user presses a button like 'SAVE'.
I'm guessing the user scans the barcode on the reader n times for n orders.
You could set things up so if the user holds down the cntrl key the number of orders is reduced by one per scan.
i am using a timer that once a timer =true then the data in the textbox enters in msflexgrid then it automatically updates the value in the database once the item was entered in msflexgrid..thats why i am asking how to update msflexgrid value and database value..