Subject RE: [IB-Architect] proc directory type information tables
Author Ann Harrison
>At 02:14 PM 2/9/01 -0800, Lee Rodgers wrote:

>The INSERT syntax should look
> >like UPDATE's so you avoid common placement mistakes
> >with INSERT like:
> >INSERT (name1 name2 name3) (value2 value1 value3)

At 05:31 PM 2/9/2001 -0500, Jim Starkey wrote:

>The basic reason is that insert has to accomodate input
>from a select statement and update doesn't.

Relational theory tells us that you should never update
more than one column in any table with values from another
table (transitive dependency, I think). However, the
difference between theory and fact shows up in compound
primary keys (probably also theoretically unsound) and
other design compromises.

In short, being able to update from a select would be
a good thing.


We have answers.