RE: SQL Concepts - Header and Detail

["Joe Pluta" <joepluta@xxxxxxxxxxxxxxxxx>]

> From: Walden H. Leverich
>
> Others have pointed out how to do this (and it even sounded like Joe
> _liked_ SQL :)

Oh great snarky one!  <LOL!>

Truly, though, I love SQL.  I use it constantly.  I just don't like seeing
it abused.


> but this also raises the question, why are these out of
> sync in the first place, and should you actually be asking about a
> trigger on the detail table that keeps the header table in sync
> automatically? Just something to think about.

Yeah, I thought about this, too.  In fact, I think about this in general
when people are using SQL statements.  Are they doing one-time fixes to
files?  Or are they writing a procedure that should be handled either by a
trigger as you suggest or by simple good database integrity that doesn't
allow unauthorized writes to the file.

Joe