Re: INSERT SP

Article View: borland.public.interbase.sql

Article #916

Back to borland.public.interbase.sql Previous Next

#916

From: Maxim Shiryaev
Date: Fri, 20 Apr 2007 11:33

36 lines
1624 bytes

SUSPEND is not required.

But a semicolon after any SQL statement is. In this case just after the
C_HISTORIA.

Maxim.


"nuria" <nurianeurop@yahoo.es> ???????/???????? ? ???????? ?????????:
news: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: <4628a4ef@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!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-7-bit
From: "Maxim Shiryaev" <MaximShiryaev@gmail.com>
Newsgroups: borland.public.interbase.sql
References: <462891c7$1@newsgroups.borland.com>
Subject: Re: INSERT SP
Date: Fri, 20 Apr 2007 15:33:50 +0400
Lines: 38
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 213.234.197.62
Message-ID: <4628a4ef@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1177068783 213.234.197.62 (20 Apr 2007 04:33:03 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message