Questions tagged [firebird]
An open-source DBMS platform descended from Interbase.
76
questions
0
votes
0answers
146 views
Firebird: show tables command shows no result in different environment
I'm using firebird with docker with the image jacobalberty/firebird:2.5.8-sc
I use it in local and in the remote server. The problem is the database seems unreadable in the remote server, it says no ...
2
votes
1answer
83 views
Filter on value in another row
Please see image of the data and my code so far.
In this example I only want the first two rows to be retrieved. The reason for this is because where JobID is 1684 the sum of STILL_REQUIRED is > 0
...
0
votes
2answers
72 views
SQL firebird dont select rows with 0
This works fine, except in the results, I don't want the rows where STILL_REQUIRED is 0.
I am using firebird.
Select ID, JobID, NAME, ORDERNUM, STARTAFTER, FINISHBEFORE,
START_OFFSET_MINS,
...
1
vote
1answer
41 views
Hide table structure to users in firebird
I have been searching for a way to hide tables structures for some user but without success. I need that some users can only browse two views, but they don't be able to browse tables structures.
Is ...
1
vote
1answer
192 views
Current Date in where clause
How do I put current date into the where clause without having to type it in all the time?
Select SALEITEMS.SKU,
STOCK.SHORTDESC,
SALEITEMS.SALEPRICEEX,
...
0
votes
1answer
635 views
How to trace a query on Firebird?
With SQL Server we can trace for a period of time, to get what queries are running.
How can I do this with Firebird? I'm reading something on their website but there's only user trace like if the ...
2
votes
1answer
534 views
Firebird query pivot
I have a Firebird sql query that returns 3 fields: Surname, Name and date as (YYYY-MM-DD HH:mm:ss)
select Surname, Name, "WHEN" from users
left join attendant on (users.id = attendant.userid);
This ...
0
votes
1answer
232 views
Recreate existing database with a different charset
I want to change the character set of an existing database from none to utf8,
it seems that the safest way is to create a new one then pump data to it.
I have tried two methods, both gave me the same ...
1
vote
0answers
110 views
Migrate Firebird to Oracle
I have about more than 250 Firebird local databases and several server databases. The way they are connected is such:
A block of almost 50 local databases, 1 on each PC, connect to 1 server database. ...
1
vote
2answers
178 views
Firebird total column [closed]
I have a query that I am struggling with. The problem I have is that I would like it to just display a total of column variancevalue as a result.
SELECT
DEPARTMENT.DESCRIPTION AS DepartmentName,
...
0
votes
1answer
110 views
Do I have to commit after an exception has been raised?
My database generates a lot of orphan pages, and I'm trying to figure out why.
I often do this in my python code, using the fdb driver:
cursor = connection.cursor()
for item in list:
try:
...
1
vote
1answer
344 views
Firebird execute block where External datasource is localhost
I'm writing a .net application that connect to a remote database server hosted on internet to make a sort of replication.
The database source is on my local firebird server, the destination database ...
1
vote
1answer
332 views
Firebird, select gives token unknown
I have a Firebird database with a table foo that have a field called WHEN. Is there a way to perform a query using the field name in SELECT?
This works:
SELECT * FROM foo;
This not:
SELECT WHEN ...
-1
votes
1answer
309 views
Current Date for Query
I have a query which I currently have to change the date in everytime. I would like to edit it so that it gives me all dates for the current month. Or is there a way to get it to request a date range.
...
1
vote
1answer
82 views
Firebird: table and null data
I'm working with Firebird database. I have a big table with many thousand of rows. Each line records the status of an object at regular intervals for many objects. I need to register new properties ...
2
votes
2answers
5k views
Compare sum of two select results
Using Firebird, I have two tables, Orders and DespatchedParts.
Orders table:
ID CustomerID Total_number_parts
-- ---------- ------------------
1 1 5
2 1 4
3 2 ...
0
votes
2answers
2k views
SQL Select where value = to another select [closed]
I have two tables. Orders, and OrderParts. One Order can have many OrderParts.
I want a list of all the order.customerID where the number of OrderParts ordered = Total_number_parts in the order table....
5
votes
1answer
132 views
Is it possible in Firebird to create a single index with ascending and descending columns?
For instance, something equivalent to
CREATE INDEX Listing_Date_Idx ON ACTIVITY(Listing,Date_ DESC,Time_ DESC);
0
votes
1answer
713 views
Show recent select queries on Firebird database file
Is there a way to log or query the n recent SELECT queries to an FDB database file? I have already tried using the MON$ and RDB$ tables but I didn't find anything useful.
0
votes
1answer
796 views
Firebird2.5-superclassic on Ubuntu 16.04 LTS
I installed firebird2.5-superclassic using sudo apt-get install firebird2.5-superclassic and then ran sudo dpkg-reconfigure firebird2.5-superclassic and set the password per https://firebirdsql.org/...
1
vote
1answer
562 views
How to Determine Optimal Disk Cluster Size for Firebird 2.5
I'm using Firebird 2.5.6 Classic Server on a Windows 7 64-bit machine. We're moving the database to a separate disk (32GB NTFS Volume) and are now provisioning that disk. My question is, what should ...
0
votes
2answers
110 views
Firebird Configuration: firebird.conf Parameters Unit of Measurement
Many of the parameters in the firebird.conf configuration file are integers and I'm unsure what unit of measurement (KB, Byte etc.) is being used. For example, if tweaking the TempCacheLimit param, is ...
1
vote
1answer
312 views
Export data from InterBase / Firebird database without credentials
I have an InterBase / Firebird database file of an old project for which I lost the credentials. Some information about the database, dumped with the gstat command, is shown below [1]. I'm accessing ...
2
votes
1answer
789 views
Firebird 3.0 service won't start on Windows 7
I have Firebird 2.5 classic server running on Windows 7 on port 3059. This service is set to automatically start up and it works fine.
I've installed Firebird 3.0.2 as classic server on port 3050 but ...
0
votes
2answers
790 views
How to run insert statement as much times as select statement gives unique values?
DB Firebird.
I have the following statement
SELECT a.ID FROM CLIENTS a
And I want my INSERT statement into another table to use each of this value, something like
INSERT INTO BANKS (ID, NR, MONEY)...
0
votes
1answer
604 views
Prevent Firebird's default instance from starting
I want temporarily to use another named instance. Can I prevent the default instance from starting when the PC starts? I am using Windows 8.1
0
votes
1answer
81 views
Repeating rows of date intervals Between dates Firebird
I am stuck in a case that on my financial sys, I need to add a option for value to be monthly, weekly or every 2 weeks
example:
DESC | VALUE | DATEADD | FREQUENCY
--------+---------+--------...
3
votes
1answer
3k views
How to export database structure from Firebird?
I'm doing replication and I need to export db structure from one Firebird db (dialect 3) into another. I've seen a couple tools like IBPump and FBExport, however all I can find is how to export all ...
0
votes
1answer
273 views
How to select and show all the tickets from last calendar year?
It seems SQL calls varies a lot, and cannot find how to do this in Firebird, where SQL dialect is 3.
There's a table called TICKETS. This table has INSERT_TIME which is TIMESTAMP. How do I select all ...
0
votes
1answer
956 views
Firebird: Access Denied
When ever I try to create a database with SQI Tools for firebird I receive this error...
SQL> create database 'C:\Remake'
CON> user 'sysdba' password 'masterkey';
Statement failed, SQLSTATE = ...
2
votes
1answer
574 views
Issue installing Firebird ODBC drivers — driver eventually no longer found
I am experiencing an issue with an SSIS job that connects to a Firebird DB using their ODBC driver (version 2.0.4.155).
The SSIS package runs flawlessly in Visual Studio 2008, which is installed on ...
3
votes
1answer
194 views
Query is too slow (1 second, but needs to improve)
I have generated a very large query. Unfortunality this query is too slow for us. The query is 1 second, but it needs to improve too less than a few ms. I don't want duplicates of the result. So I ...
0
votes
1answer
500 views
How to Enable Windows Authentication in Firebird 2.5
I am trying to enable Windows Authentication on a remote Firebird 2.5 database. I modified the Firebird config file and changed the authentication method to 'MIXED', restarted the Firebird services ...
2
votes
0answers
291 views
How does the use of derived tables speed up sorting?
In the article 45 Ways To Speed Up Firebird Database, it states that
Use derived tables to optimize SELECT with ORDER BY/GROUP BY
Another way to optimize SQL query with sorting is to use ...
0
votes
1answer
1k views
Migrating data from Firebird to CSV on OSX
I have a .gdb Firebird database file that I would like to partially transform to .csv. From the CLI tool, I'm able to do the following:
CONNECT "/Users/jpmonette/Desktop/file.gdb";
OUTPUT /Users/...
2
votes
1answer
250 views
how many cores uses gbak (firebird) on restoring?
I'm restoring db, and I see that firebird uses only one core of my CPU for gbak and fb_smb_server:
Is it normally? I've 4 cores in my CPU.
CpuAffinityMask parameter in firebird.conf is commented out.
0
votes
1answer
81 views
Get value from nearest (lower) integer
As jkavalik sais: I'm looking for "the greatest value not greater than". I have a table containing a kind of IDs and values like those
ID value
101 A
2003 B
4005 C
when searching for "...
2
votes
1answer
126 views
Detect circular relations in a distribution table
I have the following two tables, that will define distribution rates from items on table A to other items on table A (I think I can say B defines a many-to-many relationship for A with itself).
...
0
votes
1answer
3k views
How to GRANT/REVOKE user permissions for user on Firebird 1.5?
I need to create a user in firebird 1.5 and give him permissions to access only some specific tables.
I have managed to create the user, but apparently GRANT/REVOKE operations only work on version 2.1 ...
0
votes
0answers
1k views
Firebird Guardian
Is there an opinion on running Firebird Guardian. According to the FAQ - The Firebird FAQ:
On Windows, having guardian running can even be counter-productive as
it would run fbserver.exe instead ...
2
votes
1answer
2k views
Join more than 3 tables in one single query, with many comparisons and no IDs
I use an overlycomplex and poorly designed software at my work, and now I need to produce a report of invoices issued between a period of time.
Invoices are held at table ENTR2012, which uses the ...
1
vote
1answer
1k views
Firebird Index Creation Fails
I'm creating an index in a table with the following command:
CREATE INDEX IDX_CVE_OBS ON FACTF01 (CVE_OBS);
But it returns me the following error:
this operation is not defined for system tables. ...
0
votes
1answer
1k views
Firebird linked tables in Access 2010
I have multiple data sources in multiple databases that I have been tasked with correlating for business analytics. I currently have ODBC connections to two (one Pervasive, one Firebird) that I can ...
1
vote
0answers
130 views
ExecuteNonQuery struck and control never come back to next line in vb.net with firebird
I am using vb.net with firebird 2.5. I have a grid which has 100,000 records have to insert/update in the database but as I run loop it stuck in ExecuteNonQuery statement. few lines work but after ...
1
vote
1answer
1k views
How to stop Firebird SuperClassic (run as application) in Win 7?
I run Firebird 2.5.3 SuperClassic as application in Windows 7 64-bit with this command:
fb_inet_server -a -m
Now, how can I stop/shutdown it from command prompt? I know that I could right-click its ...
1
vote
1answer
989 views
Can't restart or stop Firebird 1.5 on linux
I have an ubuntu server running firebird 1.5. It was working fine, but recently it started hanging (firebird does not respond anymore). Even when trying to restart or stop the server, it shows an ...
2
votes
1answer
6k views
Firebird 2.5. Windows 8.1. Can't connect to any database! Why?
I'm trying to use a FireBird database engine.
OS: Windows 8.1 x64(SmartScreen enabled, UAC enabled, Custom AntiVirus installed(with firewall))
FireBird: Version 2.5, Installed as SuperServer, as ...
1
vote
0answers
655 views
firebird update very slow
I am writing a stored procedure for Firebird 2.5 in which I sometimes need to update a single row in a data table more than once in the same transaction. However, I have noticed that the performance ...
2
votes
1answer
805 views
adjecency list model vs nested sets
I've stumbled upon an article describing nested sets model for storing hierarchical data and was quite intrigued by the supposed performance boost.
after implementing this in our database, i've found ...
1
vote
1answer
398 views
How to deploy case-insensitive embedded firebird database?
I'm trying to find out how to create CI firebird embedded database. I've found (here) that there are some character sets each of them has one or many collations. So, UTF8 has UCS_BASIC, UNICODE and ...
