>>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.

Hi Erik.
The "Trigger failed" message is stored in wizstyle class lib. You can open txtbtns class. There is a method named "updaterow". The messages are defined at the begining of this method.

Hope this help
Sunny

Can you live without the earth?
Please remind that :
"Yung Hung" is my first name;
"Yeung" is my last/family name.