Hej,
On 09.05.2015 23:11, vrynjo...@yahoo.com [firebird-support] wrote:
>
>
> Trying to create an odbc DSN for a .gdb database on firebird
> 1.5.6.5026-0 32bit. the os is windows 7 32 bit and the odbc driver is
> Firebird odbc 2.0.0.151 32bit. Database connection is successful in
> iBExpert but
Please check this :
SET TERM ^ ;
ALTER PROCEDURE SP_VERSION_NOS (
PORTION smallint,
SEPARATOR char(1),
VERSION_UPTO varchar(80) )
RETURNS (
VERSION_NO varchar(80) )
AS
declare variable i smallint;
declare variable SEPARATOR_POS Integer;
declare variable VERSION_UPTO_PORTION_INT int
Please try :
SET TERM !! ;
alter PROCEDURE SP_VERSION_NOS(
PORTION smallint,
SEPARATOR char,
EARLIER_TO integer)
RETURNS (
VERSION_NO varchar(80)
)
AS
declare variable i smallint;
declare variable SEPARATOR_POS Integer;
declare variable VERSION_PORTION varchar(80);
declare variable