"Gail Shaw" <initialsurname@sentech sa dot com> wrote:

> Shame. I feel for them (not)
> That's what they get for not using stored procedures.

In their defense, a lot of the code is for generating SQL on-the-fly for viewing
certain windows, screens, whatever, based on the user selecting certain options
in whichever screen they're using.  BTW we're talking about a telco billing
application with over 300 tables and a huge number of windows, screens,
dropdowns, etc., used to manage customers, billing, delinquencies, switch
activation, trouble tickets, external plant management (all the cables and
telephone poles -- the physical components that carry the phone/cable/internet
service to a house/business).  They do use a large number of stored procs for
the real heavy-lifting (I counted almost 700).

--
Dan
GoofyGraffix.com

Post a reply to this message