RE: reduce your I.T. backlog by granting SQL UPDATE/DELETE/ capability to user community!

FWIW i think this is a very good case for RI and foreign constraints...


Thanks,
Tommy Holden



From: Bryce Martin <BMartin@xxxxxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 05/27/2010 07:19 AM
Subject: RE: reduce your I.T. backlog by granting SQL
UPDATE/DELETE/ capability to user community!
Sent by: midrange-l-bounces@xxxxxxxxxxxx



Yeah, we have a product that our users use to do mass updates. Only
problem so far was when someone created 90,000 items in the item master
for a new product line and put the wrong item class on it... valid class,
passed the logic tests.... still wrong! Thanks to the integral part that
item class plays it only too a week to run our update program to fix it.
So, 85 sql statements per item finally fixed it right up. Gotta love the
'power users', one day they are a great asset because they don't bother
you, but when they do, its usually enough work to make up for lost time.


Thanks
Bryce Martin
Programmer/Analyst I
570-546-4777



rob@xxxxxxxxx
Sent by: midrange-l-bounces@xxxxxxxxxxxx
05/27/2010 07:02 AM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
cc

Subject
RE: reduce your I.T. backlog by granting SQL UPDATE/DELETE/ capability

to user community!






There's a company that sells a product which will read files and do the
same thing. Useful for batch uploads and stuff.


Rob Berendt