Stack Overflow
Stack Overflow

Questions tagged [firebird2.5]

For questions specific to Firebird 2.5. It is advisable to also tag with firebird.

Firebird 2.5 is an - end-of-life - version of the Firebird database server.

Firebird is the universal open source database used by approximately 1 million of software developers worldwide to implement wide range of database applications: from embedded systems to terabyte-size enterprise solutions. Firebird supports ACID, triggers, stored procedures, UDF and events; it runs on 32- and 64-bit versions of Windows, Linux, MacOS X, HP-UX, FreeBSD, etc.

Firebird 2.5 enables to achieve better stability and performance. Version 2.5 of Firebird brings a new level of quality to the world of open-source databases whilst upholding the Firebird database principles of free development and deployment.

The primary goal for Firebird 2.5 was to establish the basics for a new threading architecture that is almost entirely common to the Superserver, Classic and Embedded models, taking in lower level synchronization and thread safety generally.

Although SQL enhancements are not a primary objective of this release, for the first time, user management becomes accessible through SQL CREATE/ALTER/DROP USER statements and syntaxes for ALTER VIEW and CREATE OR ALTER VIEW are implemented. PSQL improvements include the introduction of autonomous transactions and ability to query another database via EXECUTE STATEMENT.

For more information, see the Firebird 2.5 download page.

Resources

See also

644 questions
26
votes
5 answers

How to decide when use index on table column

When should I use index on table? From how many rows index makes sense? If I have table with constant rows, just edited come columns (not in 'where' clause), makes index sense even if table has just about 15 rows? EDIT: Can be in such case…
Fanda
  • 3,760
  • 5
  • 37
  • 56
14
votes
3 answers

Get list of column names from a Firebird database table

How do you get a list of the column names in an specific table? ie. Firebird table: | name | id | phone_number | get list like this: columnList = ['name', 'id', 'phone_number']
jramirez
  • 8,537
  • 7
  • 33
  • 46
11
votes
2 answers

Firebird - get all modified fields inside a trigger

I need to get all the values which changed in a row and post modifications on other 'audit' table. Can I accomplish this, without writing the conditions for each element from the row? I know the SQL from http://www.firebirdfaq.org/faq133/ which…
RBA
  • 12,337
  • 16
  • 79
  • 126
10
votes
8 answers

How to SELECT a PROCEDURE in Firebird 2.5

I'm using Firebird Embedded v2.5. How to use procedures in query (SELECT) ? My procedure: SET TERM ^ ; CREATE PROCEDURE FN_TEST( Y INTEGER ) RETURNS( X INTEGER) AS BEGIN X = Y + 1; END^ SET TERM ; ^ I want to list some field of table modified by…
Emil
  • 101
  • 1
  • 1
  • 3
10
votes
2 answers

How to check in which server mode (e.g. SuperClassic or Superserver) a Firebird database is running?

The latest Firebird 2.5.x database can run in either Classic, SuperClassic, or SuperServer mode. How can I check in which of these modes an installed database is running?
Jan Derk
  • 2,552
  • 27
  • 22
9
votes
6 answers

How to split comma separated string inside stored procedure?

How to split comma separated string into strings inside store procedure and insert them into a table field? Using Firebird 2.5
Yordan Yanakiev
  • 2,546
  • 3
  • 39
  • 88
9
votes
2 answers

Update a table with join?

I am trying to update table A with data from table B. I thought I can do something like this update A set A.DISCOUNT = 3 from INVOICE_ITEMS A join ITEM_PRICE_QUNTITY B on A.ITEM_PRICE_NO = B.ID where A.INVOICE_ID = 33 but getting error SQL…
Azad
  • 5,144
  • 4
  • 28
  • 56
9
votes
2 answers

Define variable and run a query using EXECUTE BLOCK

I have a large query in Firebird (which I run using FlameRobin), using a parameter all over the place, but getting the query below to run will do: SELECT * FROM customers WHERE customerid = 1234; I want to define 1234 as a variable, say customerID,…
Valentin Despa
  • 40,712
  • 18
  • 80
  • 106
8
votes
1 answer

Cast as Int only when character is a number on Firebird 2.5

I have a query that I use on a MySQL database that orders the result, casting a char database field to integer when possible (when the char string is numeric), so for example the ORDER BY clause that I use on MySQL is: ORDER BY CASE WHEN…
aleroot
  • 71,077
  • 30
  • 176
  • 213
8
votes
2 answers

Entity Framework NullReferenceException calling ToList?

I'm very new to WPF and the EF, and I'm trying to display some data from a table in a datagrid. I've got the entity model pulled from an existing database and simple operations seem to work (getting row counts, using 'first'). I'm running against…
DaveK
  • 709
  • 7
  • 21
8
votes
1 answer

Simple Firebird query very slow

I have a table with roughly 246k records. It has about 25 columns, all are integers except one small blob. If I Query the table on all fields select a.recordid, a.editcount, ect.. from ARTrans a It executes in under a second. But if I include only…
cjmarques
  • 632
  • 1
  • 7
  • 17
8
votes
4 answers

Firebird Error while trying to create file, Permission denied

I'm trying to create a Firebird database in my home directory through Flamerobin however I always get *** IBPP::SQLException *** Context: Database::Create Message: isc_dsql_execute_immediate failed SQL Message : -902 Unsuccessful execution caused…
saimiris_devel
  • 667
  • 1
  • 6
  • 19
8
votes
1 answer

Is it possible to know the level from the last incremental backup, made with nbackup from Firebird?

It's a pretty straightforward question. Firebird has a backup tool called nbackup whereas you can make incremental backups. The tool complains if you don't make the backup in the correct order (e.g. you make a level 0 backup, then a level 2). Then,…
user1492491
8
votes
2 answers

Can't connect to local Firebird with ISQL

I'm trying to setup a local firebird instance to test against but am unable to connect to it with even ISQL. I have tried to following by following the quick start guide here: CONNECT ..\examples\empbuild\employee.fdb user SYSDBA password…
Luke Chamberlain
  • 430
  • 2
  • 5
  • 17
7
votes
2 answers

Can't declare variable in Firebird 2.5, why?

I have a one line query: DECLARE VARIABLE var_SecondsOfTime INTEGER; But after running the query I am getting this message: Engine Error (code = 335544569): Dynamic SQL Error. SQL error code = -104. Token unknown - line 1, column 9.…
Wodzu
  • 6,932
  • 10
  • 65
  • 105
1
2 3
…
42 43