Syntax problem

Article View: borland.public.interbase.sql

Article #808

Back to borland.public.interbase.sql Previous Next

#808

From: philhege
Date: Thu, 10 May 2007 15:37

35 lines
1859 bytes

TIA for your assistance and expertise.  I spent a couple of Google
hours on this and am stumped.

I have this code for an SP:

SET TERM ^ ;

CREATE PROCEDURE name

AS
DECLARE VARIABLE variable_name DATE ;
BEGIN
variable_name = EXTRACT(DAY FROM current_date) + 1 ;
SELECT * FROM Mytable WHERE CAST(datetime AS DATE) < :variable_name ;
END
^

SET TERM ; ^

And am getting the following error:

SQL Message : -104
Invalid token

Engine Code    : 335544569
Engine Message :
Dynamic SQL Error
SQL error code = -104
Token unknown - line 9, char 68
;

The error occurs at the semicolon which ends the SELECT statement.  It
seems I can't get these terminators in the right place

Any corrections, pointers, etc. are appreciated.

Technical Details

Message-ID: <1178811432.614753.73230@e51g2000hsg.googlegroups.com>

Path: arc1-ca.pugleaf.net!g2news1.google.com!postnews.google.com!e51g2000hsg.googlegroups.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,24b201d9e19c2a2b,start
X-Google-Attributes: gid114a0e,public
X-Google-Language: ENGLISH,ASCII-7-bit
Path: arc1-ca.pugleaf.net!g2news1.google.com!postnews.google.com!e51g2000hsg.googlegroups.com!not-for-mail
From: philhege <pdhpoolplayer1957@yahoo.com>
Newsgroups: borland.public.interbase.sql
Subject: Syntax problem
Date: 10 May 2007 08:37:12 -0700
Organization: http://groups.google.com
Lines: 36
Message-ID: <1178811432.614753.73230@e51g2000hsg.googlegroups.com>
NNTP-Posting-Host: 12.145.217.102
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1178811432 21580 127.0.0.1 (10 May 2007 15:37:12 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 10 May 2007 15:37:12 +0000 (UTC)
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; InfoPath.1; .NET CLR 2.0.50727),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: e51g2000hsg.googlegroups.com; posting-host=12.145.217.102;
   posting-account=6VBDSAwAAAAR9naoA1h3dK3aczBNdhIN