[firebird-support] Ubuntu 3.0.5 version

Mariuz's Ubuntu repository contains version 3.0.5.33100 and was released in October 2019. The official version on the Firebird website is 3.0.5.33220, released in January 2020. This is ok in terms of stability, if I want to use the Ubuntu package? Thanks

Re: [firebird-support] "Invalid Cursor State"

I´m not sure which was the solution that finally worked, as I´ve made several changes, mostly on the execution order in my program (windows exe, not FB). I suppose there is some issues with ODBC driver _and_ Clarion, but I´m not really sure about it. Regards 2017-10-18 15:19 GMT-03:00 'Leyne,

Re: [firebird-support] "Invalid Cursor State"

@ibphoenix.com > [firebird-support] <firebird-support@yahoogroups.com>: > > 17.10.2017 20:12, Jorge Andres Brugger jorge.brug...@gmai

Re: [firebird-support] "Invalid Cursor State"

> 17.10.2017 20:12, Jorge Andres Brugger jorge.brug...@gmail.com > [firebird-support] wrote: > > What am I doing wrong? > >You cannot fetch from non-s

[firebird-support] "Invalid Cursor State"

Please consider the following SP: create or alter procedure SP_VAL_REGISTRAR_CANCELACION ( SUCURSAL smallint, ID_SOLICITUD_A_CANCELAR numeric(8,0)) returns ( ID_SOLICITUD_CANCELACION numeric(8,0)) as declare variable NUMERO_ITEM numeric(9,0); declare variable IMPORTE_UNITARIO

[firebird-support] Cannot create sequence

Hello all. To use a replication solution (not longer maintaned) i need to create a generator/sequence named "RDB$GEN_REPLICADOR" but when I try to do it i get (using Flamerobin): Error: *** IBPP::SQLException *** Context: Statement::Execute( CREATE GENERATOR RDB$GEN_REPLICADOR ) Message:

[firebird-support] Re: Cannot create sequence

Solved. I was missing to do GRANT USAGE ON SEQUENCE RDB$GEN_REPLICADOR TO [user] WITH GRANT OPTION (Sequence seems to be considered system one and dont get listed) Regards! 2017-09-22 21:44 GMT-03:00 Jorge Andres Brugger : > Hello all. > To use a replication solution

Re: [firebird-support] "Name longer than database column size." on already compiled SP

Thanks Sean. But, how that variable ended there? The SP is actually working, and I can get the DDL with 33 char lenght variable name. Could be a previous FB bug? Regards 2017-09-06 14:29 GMT-03:00 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support] : >

[firebird-support] "Name longer than database column size." on already compiled SP

I already have this SP in a DB (compiled, and using it a lot): > create or alter procedure SP_INGRESOS_PEDIDOS_POR_FECHAS ( > SUCURSAL smallint, > CODIGO_PRODUCTO integer, > FECHA_DESDE date) > returns ( > INGRESOS_PEDIDOS integer, > INGRESOS_PEDIDOS_FRACCIONES integer) > as

Re: [firebird-support]

Thanks Dimitry. I'm pretty dumb today ... Regards 2017-08-24 15:02 GMT-03:00 Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] <firebird-support@yahoogroups.com>: > 24.08.2017 20:00, Jorge Andres Brugger jorge.brug...@gmail.com > [firebird-support] wrote: > > It´s "

[firebird-support]

I have this table: CREATE TABLE TRAZABILIDAD_ERRORES ( CODIGO_ERROR SMALLINT, DESCRIPCION_ERROR VARCHAR(400), TIPO_ERROR SMALLINT ); When I try to add a PK: ALTER TABLE TRAZABILIDAD_ERRORES ADD CONSTRAINT PK_TRAZABILIDAD_ERRORES PRIMARY KEY (CODIGO_ERROR); I get:

Re: [firebird-support] Cast as domain in view - wrong datatype

o not output decimal(14,0)? Thanks a lot! 2017-08-24 10:22 GMT-03:00 Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] <firebird-support@yahoogroups.com>: > 24.08.2017 14:49, Jorge Andres Brugger jorge.brug...@gmail.com > [firebird-support] wrote: > > View GTIN fie

[firebird-support] Cast as domain in view - wrong datatype

Please check the following view def: CREATE OR ALTER VIEW VW_TRZ_ERRORES( CODIGO_ERROR, DESCRIPCION_ERROR, GTIN, SERIE, FECHA, TIPO_ERROR) AS select errores.error, errores.descripcion, errores.gtin, errores.serie, errores.fecha, coalesce(trazabilidad_errores.tipo_error,0)

Re: [firebird-support] Evaluate "empty" string

That's right! I was focusing in the wrong place! So stupid me! Thanks a lot (also to Michel). 2017-08-16 13:20 GMT-03:00 Mark Rotteveel m...@lawinegevaar.nl [firebird-support] <firebird-support@yahoogroups.com>: > On 16-8-2017 17:53, Jorge Andres Brugger jorge.brug...@gmail.com &g

[firebird-support] Evaluate "empty" string

Hello all. I need to evaluate if one SP varchar parameter is "not empty". I´m using: if (((CHAR_LENGTH(trim(terminal))>0) or (terminal is not null)) then . If I send '' (empty string) as parameter content, the expression evaluates to true (I´m expecting to get a false). What am I doing wrong?

[firebird-support] About security DB backup

https://www.firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-compat-upgrade-secdb.html says: Under the Firebird 2.5 server, back up the security database. Here, use the SYSDBA password for the v.2.5 installation: gbak -user sysdba -pas masterkey -b {host/path}security2.fdb