RE: How does this work
S SATHISHI-SI:
Dear friend :
Is'nt important the why, is important the next:
select max(col1) from tab_a into max_value;
update tab_a set tab_a.col1 = max_value;
why the other way, if exist the easy way...
Bi
Michael Cherdtenson
----------
} De: S SATHISH-SI <ssathish@getafix.cmc.net.in>
} A: informix-list@rmy.emory.edu
} Asunto: How does this work
} Fecha: Thursday 16 de October de 1997 09:31
}
}
} Hi,
} In a query such as this
} update tab_a set tab_a.col1 = (select max(col1) from tab_a)
} RETURNS errno -360
}
} The message is ,one cannot refer to the table referred in the
subquery,cos
} there is a danger of getting into an Infinite loop.
}
} When can an infinite loop occur? Why is this disallowed?
}
}
****************************************************************************
**
} S.Sathish
} email :ssathish@cmcbang.ernet.in
}
****************************************************************************
**
}