Re: debug stored procedures

Article View: borland.public.interbase.sql

Article #227

Back to borland.public.interbase.sql Previous Next

#227

From: Isaac
Date: Sat, 14 Jun 2008 20:52

21 lines
2020 bytes

OK but I encounter today a very strange scenario:
first after I modified my stored procedure I run Delphi to see what will 
go, I set before 3 triggers (after insert, after update and after 
delete) for "table a" which they all call one procedure with different 
parameters

then when I try to post an inserted record I get exception error that I 
try to post a null value to a none null field The big surprise is that 
field is not in "table a" I insert the record into but in another table 
"table b" which I only touch it with the update statement and "table a" 
has foreign keys on table "table a"

after alot of going around my self I deactivate the trigger which call 
the procedure then I  tried again to insert  the record and it is 
inserted normally so reactivate the trigger and try again to insert the 
record *without any change in the sql* the record inserted with the same 
data I tried before without any error !!!!!!!!!

can you explain that phenomena ??

Thanks

Technical Details

Message-ID: <48542edb$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news4.google.com!proxad.net!feeder1-2.proxad.net!213.200.89.82.MISMATCH!tiscali!newsfeed1.ip.tiscali.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <4853fd43$1@newsgroups.borland.com> <48542502$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,c1bdf611911e6915
X-Google-Attributes: gid114a0e,domainid0,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
Date: Sat, 14 Jun 2008 23:52:26 +0300
From: Isaac <no@no.com>
User-Agent: Thunderbird 2.0.0.14 (Windows/20080421)
MIME-Version: 1.0
Newsgroups: borland.public.interbase.sql
Subject: Re: debug stored procedures 
References: <4853fd43$1@newsgroups.borland.com> <48542502$1@newsgroups.borland.com>
In-Reply-To: <48542502$1@newsgroups.borland.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 41.234.198.118
Message-ID: <48542edb$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1213476571 41.234.198.118 (14 Jun 2008 13:49:31 -0700)
Lines: 21
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news4.google.com!proxad.net!feeder1-2.proxad.net!213.200.89.82.MISMATCH!tiscali!newsfeed1.ip.tiscali.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message