Re: Error Handling Coming Out of a Trigger

Try raising the exception, then rolling back the transaction.

That did not work, but thank you though. What I have decided to do is to
separate the business rule enforcement from the database and try to allow
the database to just maintain data integrity through keys and constraints
and not forced logic, as much as possible. Kevin, I got this idea from a
conversation you and two other guys were having. I googled it up in
groups...

Did you go this way as well? If so, are you happier with it?

Thanks,

brian


.

Relevant Pages

  • Re: Ada DB bindings and APQ
    ... The database client "interface" from an object perspective ... Environment ... The connection ... This is why they began as separate ...
    (comp.lang.ada)
  • RE: "Module" option does not show up when setting permissions.
    ... It's by design. ... Access 2000 introduced the separate VBA ... Project for handling the code (notice the separate code window (VB Editor) ... an MDE database file out of it if you want to hide the source code from ...
    (microsoft.public.access.security)
  • Re: forms for tables set up as "one to one"
    ... I wish to set up a database to track all the tasks our marketing department ... file, print specs, and notes to the vendor. ... cases, the vendor, client, mailing house, etc each had separate tables. ... EstimatedDesignCost (currency) ...
    (microsoft.public.access.gettingstarted)
  • Re: a question regarding separate mdbs in Access
    ... All of the rest put into a front end mdb including Queries, ... You can separate 'code' from the actual data. ... Access Database Application with compiled VBA'). ... MS Access when it comes to various 'developer' versions hasn't been quite as ...
    (microsoft.public.data.ado)
  • Re: Temporary tables
    ... I guess it depends on how the Terminal Services sessions are configured. ... the database will create its temporary mdb in a different folder from ... The individual users need separate tables not to save the data, ... John Nurick [Microsoft Access MVP] ...
    (microsoft.public.access.externaldata)