×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.