>However - when I do the same thing from SPT in VFP - SQLEXEC does not seem to "know" that my error happened (though the record is still correctly prevented from being deleted) SQLEXEC just retruns 1 and assumes eveything is fine. So question, what do I need to do for VFP to realize that the trigger issued a ROLLBACK and a RAISEEROR and to get that message from RAISERROR into VFP for user notification purposes?
>
That's wierd. Can you return Flase from the trigger. If SQLExec() returns a -1 (negative one) it means there was a problem and you are supposed to be able to use aerror() to get info on the error. But, if you are getting a 1 returned, it seems that SQL doesn't see a problem.
> RAISERROR ('My error message', 10, 1) with SETERROR, NOWAIT
>
RaiseError sounds like something that would create a COM Event. Is that valid for ODBC access, or only for COM access?
BOb
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only