🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.interbase.sql
Article #312

Re: passing information to be displayed in exception ??

#312
From: Bill Todd [TeamB]
Date: Mon, 19 May 2008 19:05
21 lines
1827 bytes
Isaac wrote:

> Then I check if there is error (record) exists in the table, right ?

Right. When your client application gets the exception it looks in the
table to get the variable information then creates the message you want
to show to users and displays the message.

> 
> another question please, when triggers fires, when post changes or
> when committed ?

Triggers fire when the record is inserted, updated or delete in the
database. Any change made by the trigger occurs in the context of the
transaction that caused the trigger to fire so other users will not see
the change made by the trigger until the transaction commits and
rolling back the transaction will roll back any changes made by the
trigger.

-- 
Bill Todd (TeamB)
Technical Details
Message-ID: <4831cf78@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!feeder.news-service.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail
References: <4831a020@newsgroups.borland.com> <4831c7a5$1@newsgroups.borland.com> <4831cc19@newsgroups.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Thread: 114a0e,4bd5c26775487a13
X-Google-Attributes: gid114a0e,domainid0,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Bill Todd [TeamB]" <no@no.com>
Subject: Re: passing information to be displayed in exception ??
Newsgroups: borland.public.interbase.sql
References: <4831a020@newsgroups.borland.com> <4831c7a5$1@newsgroups.borland.com> <4831cc19@newsgroups.borland.com>
Organization: The Database Group, Inc.
User-Agent: XanaNews/1.18.1.9
X-Face: ":yn4zt^A_dn>6~{YJmu^B\'4w)e:apPM\VC=Dvf&*tASxX9|BYczkFd$xr.$vNSZ[3Uobr p]c4\+\l){!WQI.$]veP({HLd;CDYH?iN
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 76.208.40.243
Message-ID: <4831cf78@newsgroups.borland.com>
Date: 19 May 2008 12:05:28 -0700
X-Trace: newsgroups.borland.com 1211223928 76.208.40.243 (19 May 2008 12:05:28 -0700)
Lines: 21
X-Authenticated-User: btodd
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!feeder.news-service.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail