>Think someone asked about this before, but I missed it.
>
>When a trigger is being activated, all it shows is "Trigger failed." .. been looking at the Stored procedures, like __RI_DELETE_
and see it do a DO rierror with -1, "delete restrict rule violated.","",""
>
>And with a little debug-tracing, I see it put the string into an array called GaErrors. But I never see that message. And HOW do I set my own message so I dont have to see that "trigger failed" everytime..
>
>TIA
>
>Erik
Erik: Are you using an error handling routine called with ON ERROR ? If so, then you can trap each error code and enter your own messages. I use my own specific messages depending on the table in use when the user can't delete a parent record, and more generic (but much more friendly than the VFP version) messages in other places.
