INSERT SP

Article View: borland.public.interbase.sql

Article #914

Back to borland.public.interbase.sql Previous Next

#914

From: nuria
Date: Fri, 20 Apr 2007 10:11

24 lines
1283 bytes

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: <462891c7$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news2.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

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,f9548aaee3e347ab,start
X-Google-Attributes: gid114a0e,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "nuria" <nurianeurop@yahoo.es>
Sender: "nuria" <nurianeurop@yahoo.es>
Reply-To: "nuria" <nurianeurop@yahoo.es>
Subject: INSERT SP
Newsgroups: borland.public.interbase.sql
X-User-Info: 80.58.205.38     
X-Forwarded-For: 80.25.195.180, 192.168.1.66
NNTP-Posting-Host: 207.105.83.66
Message-ID: <462891c7$1@newsgroups.borland.com>
Date: 20 Apr 2007 03:11:19 -0700
X-Trace: newsgroups.borland.com 1177063879 207.105.83.66 (20 Apr 2007 03:11:19 -0700)
Lines: 24
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.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