>Jim:
>AERROR() shows Error 1547, "Cannot insert an empty row from a view into its base table". When I look up error 1547, it states that you cannot insert a blank record into a table. There is only one new row in the view, and it has something in it, so its not blank. I'm still stumped.
>
>Ed
Ed,
I just notice d anothr syntax error in the sample code, you have END TRANSACTION as one word instead of two. Try fixing that and see if the same thing is happening.