Re: Trigger and Stored Procedure Help

Article View: borland.public.interbase.sql

Article #603

Back to borland.public.interbase.sql Previous Next

#603

From: Wayne Niddery [TeamB]
Date: Sat, 11 Aug 2007 23:35

38 lines
2030 bytes

Roy wrote:
>
> 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
>
> But the Trigger does not complile. I get an error when creating hte
> trigger.

You need variables and need to select into them. e.g:

AS
  declare variable sdate date;
  declare variable msc varchar(10);
begin
  if (NEW.STOP_TIME = '12:00 PM') then
  begin
    SELECT OUT_DATE, OUT_MSC
    FROM NEW_PROCEDURE(CURRENT_DATE)
    INTO sdate, msc;

    /* do something with sdate and msc */
  end
end;

-- 
Wayne Niddery - Winwright, Inc (www.winwright.ca)
"We've all heard that a million monkeys banging on a million
typewriters will eventually reproduce the entire works of Shakespeare.
Now, thanks to the Internet, we know this is not true." � Robert
Wilensky

Technical Details

Message-ID: <46be47d6$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!feeder.news-service.com!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <46be396c@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
Reply-To: "Wayne Niddery [TeamB]" <wniddery@chaffaci.on.ca>
From: "Wayne Niddery [TeamB]" <wniddery@chaffaci.on.ca>
Newsgroups: borland.public.interbase.sql
References: <46be396c@newsgroups.borland.com>
Subject: Re: Trigger and Stored Procedure Help
Date: Sat, 11 Aug 2007 19:35:51 -0400
Lines: 40
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 69.17.170.228
Message-ID: <46be47d6$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1186875350 69.17.170.228 (11 Aug 2007 16:35:50 -0700)
X-Authenticated-User: wniddery
Path: arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!feeder1-2.proxad.net!proxad.net!feeder1-1.proxad.net!feeder.news-service.com!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message