[firebird-support] SELECT IN wildcard

Hello, Is it possible to use wildcard somehow like this. SELECT * FROM PRODUCTWHERE PRODUCT.ID IN (:param) param will be a list or IDs or a wildcard. % does not work. Goal is to get all PRODUCT with wildcard :param Thanks, Hugo Larson

RE: [firebird-support] Create sysdba user

Thanks.

[firebird-support] Create sysdba user

Hello, I there an easy way to create another user with same privileges and can access all tables as SYSDBA? I'm ueing FB 2.5 BR, Hugo Larson

Re: [firebird-support] GBAK and NBAK restore

Hi, Unfortunately 2.5 does not have replication. I'm desperately waiting for FB4. Thx,

Re: [firebird-support] GBAK and NBAK restore

Hi Mark, Thank for the explanation. What about restoring (GBAK) both databases at a particular moment then they should be even "physically" identical at that moment? At this moment it's level 0. But then you have tell the source db where level 1 starts. Maybe by inserting something in RDB$BACK

[firebird-support] GBAK and NBAK restore

Hello, We have hundreds of Firebird SQL 2.5 running at customers site (shops) with limited Internet bandwidth. The application is a POS system. For backup we use incremental NBAK and send the N file to a remote host which are restored on the server to display sale statistics etc. When rest

Re: [firebird-support] Insert with returning pk

Thanks Mark.

[firebird-support] Insert with returning pk

Hello, Is it possible to return PK of a table insert without knowing the PK colums name? INSERT INTO TABLE1 (NAME) VALUES('TESTDATA') RETURNING Thanks, Hugo Larson.

[firebird-support] Re: Space used null values

Hi, I have a followup question. If I have a varchar(1000) column with 1000 characters in it and then i delete the value in only that column but keep the row. The row has other columns with values. Will the space be reclaimed and overwritten? BR, Hugo

Re: [firebird-support] ASCII values

Thanks Mark.

RE: [firebird-support] ASCII values

Many thanks András! //ugo

[firebird-support] ASCII values

Hello, I have a column char(2) where two ASCII values stored. For example 0011, 0001 are stored as (3,1). When I do a select I dont get any result because the result is not alphanumeric. 3 is ETX and 1 is NUL. I can get the values programmatically but I want to do bit comparison with

[firebird-support] Space used null values

Hello, Does null values take up disk space? If I have a table with 4 VARCHAR columns and I add 4 more does the table need double space even if the new columns are null? Thx, Hugo Larson

[firebird-support] Re: Two versions

Hello, Is it that simple? I found this article that say that /etc/services has to be altered. https://www.gefoo.org/generalfoo/2011/02/21/multiple-firebird-servers-on-ubuntu/ https://www.gefoo.org/generalfoo/2011/02/21/multiple-firebird-servers-on-ubuntu/ Thanks,

[firebird-support] Re: Two versions

Hi, Actually I have not tried on windows.

[firebird-support] Two versions

Hello, Does anybody know how to have two versions of Firebird running on Linux(ubuntu). I currently have 2.5 on port 3050 and would like to have 3.0 on port 3051. Thanks, hugo

Re: [firebird-support] nbackup

Hi, Interesting that FB 3.0 reduces the nbackup time. Thanks for the info. We have so many installations so I think we will wait for FB 4.0 which have incremental nbackup restore and native replication. BR, Fadi

Re: [firebird-support] nbackup

Hi Alexey, In my case the database is seldom larger 500 MB and the backup takes 30 maximum seconds. Would it not be sufficient to check the MON$BACKUP_STATE field (thanks Thomas) and if its stuck on state 1 or 2 for several minutes then I execute "ALTER DATABASE END BACKUP". How do you recove

[firebird-support] nbackup

Hello, Is there a way to ask a database if someone is performing a nbackup? If it's in "the physical backup mode". I'm always paranoid if there is a power failure during a backup and it gets stuck in that mode and I would like it to recover from such situation. We have many hundreds of installa

[firebird-support] Shutdown database issue

Hello, I'm running firebird 2.5-super on Ubuntu 16.04. I want to restore a database with nbackup and before I do that I shut down the particular database file and delete the file and after that restore. Sometimes during shutdown I get the one of these exceptions: GDS Exception. 335544835. Targ

Re: [firebird-support] JOIN ON SELECT PROCEDURE

Thanks.

Re: [firebird-support] JOIN ON SELECT PROCEDURE

Thanks Dimitry. BR, Hugo

[firebird-support] JOIN ON SELECT PROCEDURE

Hello, I wonder if I could get help on the following issue. I have a PROCEDURE GETDATES which returns all the dates of a month. 2016-12-01 2016-12-02 And this table TABLE DEBIT ID (INT) DEBITTIME (TIMESTAMP) TOTALSALE (BIGDECIMAL) Every day has multiple row of table DEBIT The request is

[firebird-support] fbtracemgr

Hello, Could someone please provide the configuration needed to trace all SQL queries executed. I'm using Firebird 2.5 with following config file. Thanks, Hugo enabled true log_transactions true log_procedure_start true log_procedure_finish true

Re: [firebird-support] nbackup problem : Database is already in the physical backup mode

Hello Mark, So if the computer is shutdown during a nbackup the database is locked in this way indefinelty? What do you suggest I should do with JayBird when the exception is thrown? Execute "alter database end backup"? BR,

[firebird-support] nbackup problem : Database is already in the physical backup mode

Hello, We have a POS application using Firebird 2.5.3 together with JayBird on about 300 sites. The applications runs nbackup several times everyday. It has happened several times on several sites that nbackup fails with following exception: org.firebirdsql.jdbc.FBSQLException: GDS Exception. 3

Re: [firebird-support] Firebird c++ API connect encoding

Thanks Mark.

[firebird-support] Firebird c++ API connect encoding

Hello, Can someone advice on how to set the encoding of the connection with Firebird C++ API "isc_attach_database" call. I want to set it to ISO8859_1 but cant find an example. Thanks, Hugo

[firebird-support] nbackup database made database inaccessible

Hello, I have encountered a serious problem with nbackup. During a automated nbackup something happened with the .delta file and the database was inaccessible until i luckily found the command "nbackup.exe -U" which addressed the problem. Nothing else worked. The error message was that the .delt