Dear List
Please help me understand where I am going wrong with creating the following
procedure:
SET TERM ^ ;
CREATE PROCEDURE TestProc
( CatName CHAR(15) )
AS
BEGIN
select cast('Now' as time) as TIME from rdb$database;
END^
SET TERM ; ^
Engine Code: 335544569
Engine Message :
Dear List
Please help me understand where I am going wrong with creating the following
procedure:
...
CREATE PROCEDURE TestProc
...
select cast('Now' as time) as TIME from rdb$database;
...
Token unknown - line 7, column 57
;
What should Firebird do with TIME? You simply need an INTO clause
Hi,
Please help me understand where I am going wrong with creating the
following procedure:
SET TERM ^ ;
CREATE PROCEDURE TestProc
( CatName CHAR(15) )
AS
BEGIN
select cast('Now' as time) as TIME from rdb$database;
END^
SET TERM ; ^
Engine Code: 335544569
Engine Message :
On Fri, Jun 8, 2012 at 7:37 AM, ktadimeti tadimetikes...@yahoo.com wrote:
**
Dear List
Please help me understand where I am going wrong with creating the
following procedure:
SET TERM ^ ;
CREATE PROCEDURE TestProc
( CatName CHAR(15) )
AS
BEGIN
select cast('Now' as time) as TIME from