Re: Trigger and Stored Procedure Help

Article View: borland.public.interbase.sql

Article #605

Back to borland.public.interbase.sql Previous Next

#605

From: Martijn Tonies
Date: Mon, 13 Aug 2007 13:32

31 lines
1846 bytes

> > What I want to do is call it from a Trigger like this;
> >
> >
> > CREATE trigger call_tmp_procedure for sysgrpperf
> > active after insert position 0
> > AS
> > begin
> > if (NEW.STOP_TIME = '12:00 PM') then
> > SELECT * FROM NEW_PROCEDURE(CURRENT_DATE);
> > end

Select all columns from the resultset of the procedure ... into? Into what?

Where does the result go?

Also, I suggest you remove the "*" but use actual names instead.

> > But the Trigger does not complile. I get an error when creating hte
> > trigger.


-- 
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

Technical Details

Message-ID: <46c05d5c$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!feeder1-2.proxad.net!proxad.net!feeder1-1.proxad.net!club-internet.fr!feedme-small.clubint.net!194.25.134.62.MISMATCH!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <46be396c@newsgroups.borland.com> <46be56d6@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,c35c8d600af0988d
X-Google-Attributes: gid114a0e,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Martijn Tonies" <m.tonies@upscene.removethis.com>
Newsgroups: borland.public.interbase.sql
References: <46be396c@newsgroups.borland.com> <46be56d6@newsgroups.borland.com>
Subject: Re: Trigger and Stored Procedure Help
Date: Mon, 13 Aug 2007 15:32:15 +0200
Lines: 33
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1807
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1896
NNTP-Posting-Host: 212.238.159.172
Message-ID: <46c05d5c$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1187011932 212.238.159.172 (13 Aug 2007 06:32:12 -0700)
Path: arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!feeder1-2.proxad.net!proxad.net!feeder1-1.proxad.net!club-internet.fr!feedme-small.clubint.net!194.25.134.62.MISMATCH!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message