Re: Switching to SQL - changing the way we'vealwaysdonethings(was:SQL for performance-etc.)

Now, with RI, the ROI is there.

Rob Berendt
-- 
"They that can give up essential liberty to obtain a little temporary 
safety deserve neither liberty nor safety." 
Benjamin Franklin 




"Richard B Baird" <rbaird@esourceconsulting.com>
Sent by: midrange-l-bounces@midrange.com
01/10/2003 01:43 PM
Please respond to Midrange Systems Technical Discussion
 
        To:     Midrange Systems Technical Discussion 
<midrange-l@midrange.com>
        cc: 
        Fax to: 
        Subject:        Re: Switching to SQL - changing the way we've 
always  donethings(was:SQL for performance-etc.)



Rob,

I have to admit that i've pretty much ALWAYS assumed just those two things
- no chain meant no record, good chain meant i can update.  good or bad,
I've just never run across the need to do anything else.

once in a great while, i've tested for the error indicator, and 'assumed' 
a
record lock, and just coded a 'try again' (a limited number of times).

For the most part though, i've written programs in such a way that a 
record
is never locked waiting for screen input.  chain (nolock) - entry/edit -
chain again, check for differences, and update.  batch updates happen fast
enough that the locks aren't long enough to notice.

i've seen a lot of home rolled error routines, but it's been my experience
that 99.9% of the time, the code is never needed.

for the 0.1%, it's usually an isolated situation, and 99% of those are
locks.

so, as i said, right or wrong, the roi wasn't there to develop a catch-all
error handling routine that i was comfortable with.

rick

-------Rob said:-------
Right on brother.

However the checking of errors has been rather free and loose even without
RI.  This just adds more reason to be concerned with some standard error
processing.  Like, if a chain works, how many people assume that the
update will work, and ignore the error handling, if they even use one?
Or, if a chain fails, how many people assume it is because the record
doesn't exist?

Rob Berendt

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo.cgi/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.