• Sean LangeI hope your code is just for an example of how to force an error because a loop is not very efficient in sql.

    Yes, An example

    Cadavre


    I can't think of any reason why you'd want to do that

    Would like to know whether we can do that or not. Remember some old vb code with "on error resume next".

    Thanks much for the reply.

    _____________________________________________
    One ounce of practice is more important than tonnes of dreams