hello!
After my reply to your question I made additional researsh and find out
some code that will be useful (I'm hope!):
In your cmdSave.Click place something like:
IF .NOT. TABLEUPDATE(.T.,.T.)
=TABLEREVERT(.T.) &&Revert the change
IF TYPE('gaErrors[1,1]') <> 'L'
=MESSAGEBOX('Trigger Failed - '+gaErrors[1,2],0,;
'Data Entry Error/Trigger Failed')
ENDIF
GO TOP
ENDIF
THISFORM.REFRESH
Have a happy day
Vladimir Shevchenko
>
> I would like to know during data entry into a table which trigger have
> failled. My objective is to intercept the message "trigger failled" to
> inform the user a message more specific.
* Human is a question asked by birth and answered by death. Machine is another kind of question with another kind of answer