[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

[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

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

[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

[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

[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.

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,

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 .delta