On Fri, Jun 8, 2012 at 7:37 AM, ktadimeti 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 rdb$data
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
> En
>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
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 :
Dyn