Re: INSERT SP

Article View: borland.public.interbase.sql

Article #915

Back to borland.public.interbase.sql Previous Next

#915

From: harun bolat
Date: Fri, 20 Apr 2007 11:14

36 lines
1730 bytes

Maybe using SUSPEND keyword cause the problem.
Because procedure does not return any value. also, semicolon is missing 
after select clause.
Try same procedure without "suspend".



"nuria" <nurianeurop@yahoo.es>, haber iletisinde �unlar� 
yazd�:462891c7$1@newsgroups.borland.com...
>
> Hi all, I can't create a procedure that consists only of an insert, 
> because I'm getting a syntax error in the final END, something's missing 
> but can't find what's wrong, the SP is like this:
>
> CREATE PROCEDURE NEW_PROCEDURE1
> AS
> BEGIN
>
>  INSERT INTO TEMPINGRESOMIN (C_HISTORIA, DATAINGMIN)
> SELECT
>  TRACTAMENTS.C_HISTORIA,
> MIN(TRACTAMENTS.DATA_INGRES)
>
> FROM TRACTAMENTS
>
> WHERE
>  /*CONDITIONS
> GROUP BY
> TRACTAMENTS.C_HISTORIA
>
> SUSPEND;
> END
> ;
>
> Thanks in advance
>

Technical Details

Message-ID: <4628a053@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newspeer1.nwr.nac.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

References: <462891c7$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,f9548aaee3e347ab
X-Google-Attributes: gid114a0e,public
X-Google-Language: ENGLISH,ASCII
From: "harun bolat" <harunbolat@netsim.net>
Newsgroups: borland.public.interbase.sql
References: <462891c7$1@newsgroups.borland.com>
Subject: Re: INSERT SP
Date: Fri, 20 Apr 2007 14:14:51 +0300
Lines: 38
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 212.174.130.50
Message-ID: <4628a053@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1177067603 212.174.130.50 (20 Apr 2007 04:13:23 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newspeer1.nwr.nac.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Reply to Parent Message