On Mon, 31 Dec 2007 13:54:50 +0000, "Hugo Ferreira" <[EMAIL PROTECTED]> wrote:
>Hmmm... Would it be possible to make a trigger on a >table such that if any update fails, it does an insert? >If so, then one would only need to issue updates. I don't think that would be possible, an update trigger most likely wouldn't fire on a failed update. The only thing you can rely on is: zero rows changed. But you could try it anyway. Experiments are always worth the effort. -- ( Kees Nuyt ) c[_] ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------