GasGiant
|
For the past 18 months we have been running a web app that does data mining, reporting, and data look ups on our live data (SELECT queries.) It is internal only at this point. We have also been doing INSERTs of data into the EDI table for order entry with this app. More recently we went to doing some of our order entry directly into the BKARINV, BKARINVL, and BKARDESC tables, as well as doing all of our RMA entries to ISSRINV, ISSRINVL, and BKARDESC. I knew it was coming. Two weeks ago the Engineering manager asked if I could give his people the ability to update Item info, like vendor part numbers and status. So, the question is, what kind of collisions might happen if I'm trying to run UPDATE queries on BKICMSTR, MTICMSTR, etc.?
|