Hello Susan,
It seems that the SetDiagnostics() is a Function, you must use
VAR=SetDiagnostics('errtxt')
(I have not tested it into a trigger set on a non-SQL file !)
If I want to refuse the update into the trigger, I make : newrec = oldrec.
This don't change the record and don't crash the program :-)
You must set the trigger on event UPDATE and time BEFORE.
My two pence.
Manu
> -----Message d'origine-----
> De : [EMAIL PROTECTED] [mailto:owner-u2-
> [EMAIL PROTECTED] De la part de Susan Joslyn
> Envoyi : lundi 1 dicembre 2008 17:16
> @ : [email protected]
> Objet : [U2] Universe triggers (still more)
>
> Hi everyone,
>
>
>
> I have the triggers working - yay! Thanks Manu! - but now I'm to the
> next
> step, and of course stumbling again! My program sets a flag when it
> wants
> to disallow the write that called the trigger. The manual seems to
> suggest
> that I could use SetDiagnostic to fail this . but I'm not even getting
> my
> program to compile and can't find further information on the syntax of
> that
> command. Anyone know how to tell the trigger to refuse the write?
>
>
>
> Susan
> -------
> u2-users mailing list
> [email protected]
> To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
