Stack Overflow
Stack Overflow

Questions tagged [firebird]

Firebird is a free and open-source, cross-platform, client-server SQL relational database management system, running on Linux, Unix, and Windows. Please mention your exact Firebird version when asking questions.

Firebird (Wikipedia) is an open-source SQL relational database management system (RDBMS) using the client-server model. It is cross-platform, running on Linux, Unix, and Windows.

It is written in C++, and is ultimately derived from the Borland InterBase 6.0 source code. Firebird is open-source, released under a non-copyleft MPL-like license. It is totally libre and free, for both open-source and commercial applications, but of course you can contribute back with code and donations to the Firebird Foundation.

Firebird and its predecessors have been in use for more than 30 years, which makes it a very mature and stable product.

Resources

Useful links

3750 questions
1
vote
1 answer

Token unkown error in stored procedure when updating on external database

create or alter procedure UPDATECAS ( VNEWSTOCK double precision, as declare variable LCCOMANDO2 varchar(256); begin LCCOMANDO2 = 'update CAS set STOCK = STOCK-' || :VNEWSTOCK || ''; for execute statement LCCOMANDO2 on external…
GMaT
  • 15
  • 3
1
vote
2 answers

How to grant a user SELECT on a restricting view in Firebird

I need to restrict SELECT access to a table in Firebird 3.0, so that not all columns can be read by the user. This FAQ entry suggests to create a view with the restricted columns and then grant SELECT only on this view. However if I do that and…
dsungaro
  • 148
  • 1
  • 11
1
vote
1 answer

Insert file in blob field with jaybird 2.1.6

I'm trying to insert a file in a blob field in a Firebird database using lib jaybird 2.1.6. First, I create a record in my database, then, with the id of record, I try to insert my file in a blob (subtype 0) field. Here is my code: public static…
Simon Mardiné
  • 510
  • 2
  • 7
  • 23
1
vote
1 answer

ibase_query(): Dynamic SQL Error SQL error code = -104 Token unknown

I've been trying to do a search filter and this error continue to appear, can someone help me out? { require_once('conn.php'); $idata = $_POST["idata"]; $fdata = $_POST["fdata"]; $sql = "Select TOP 10* from cadcli where dtcad…
Raul
  • 13
  • 2
1
vote
2 answers

Understanding the execution plan of a query

I have this SQL: SELECT * FROM Requisicao r join convenio c on c.idconvenio = r.idconvenio join empresa e on e.idempresa = c.idempresa When I execute it I get this plan of execution: PLAN JOIN (C NATURAL,E INDEX (INTEG_160),R INDEX…
Ricardo Acras
  • 35,784
  • 16
  • 71
  • 112
1
vote
0 answers

Why can't I add an entity with children on a new context via EF Core?

According to How to add a parent record with its children records in EF Core the following should work: Model…
Artur S.
  • 185
  • 3
  • 15
1
vote
1 answer

A trigger that triggers a change in a specific field Firebird 3.0

SET TERM ^ ; CREATE TRIGGER ADDPWDHASHHISTORY FOR USERS ACTIVE AFTER INSERT OR UPDATE POSITION 3 AS BEGIN INSERT INTO USERSPWDHASHHISTORY (id, USERID, FIO, PWDHASH, ATTIME) values (gen_id(GEN_PWDHASHHIS_ID,1)…
Marina Vinograd
  • 45
  • 1
  • 6
1
vote
1 answer

Connect to Firebird DB via ODBC

I am trying to connect to a firebird DB via ODBC. I have an working ODBC Windows Connection (ODBC Data Sources 32 Bit) and also an established connection via Tableau. I tried using dbConnect but was not able to set the right parameters I guess. I…
Holmer
  • 11
  • 3
1
vote
1 answer

lumen/laravel cannot get firebird database

I get project to connect lumen with firebird database. I can connect with php file. in connectFDB.php . When I setting .env and config/database.php but not working ps. I installed…
Korakot Phromchaiman
  • 21
  • 4
1
vote
2 answers

Firebird driver not found in PHP or XAMPP

I lost a day trying to connect to a firebird database when I started my first PHP project with it, so I want to share my solutions that maybe can help others in the future (or myself).
Eagle
  • 978
  • 1
  • 14
  • 27
1
vote
1 answer

Firedac: connection assigned to transactions

I'm using Delphi 10.4 with a Firebird-Database (3) and FireDac. I have a general question about transaction handling. Please have a look at the following pseudo code: write_transaction := TFDTransaction.Create; write_connection :=…
dmeier
  • 31
  • 3
1
vote
0 answers

Connecting to Firebird database in BIML

I am trying to connect to Firebird database using BIML script, but I'm getting errors about not supported keywords like "DataSource". When I change them to "Data Source" it is supported, but then BIML tries to connect to Firebird database via…
Lordzio
  • 47
  • 5
1
vote
2 answers

Is it secure to connect to database with Public IP Address and port?

There are the following parameters: I use the FirebirdSql.Data.FirebirdClient library in asp .net Now, at the test level, I connect to the remote database using the line: string workbase = "Server="public…
hamaronooo
  • 471
  • 4
  • 20
1
vote
1 answer

Problem running embedded firebird sql query in LibreOffice

I am trying to run the following Firebird SQL query in LibreOffice, which has embedded Firebird: SELECT RDB$GET_CONTEXT('SYSTEM', 'ENGINE_VERSION') AS "VERSION" FROM "RDB$DATABASE"; I get the message Syntax error in SQL statement. Can anyone tell…
Z T Minhas
  • 37
  • 6
1
vote
0 answers

Node-firebird doesn't give results if more than 3 fields in the query

I'm testing "node-firebird" with Firebird 2.5 and it runs if I query for 1, 2 or 3 fields, but if I ask for a fourth field, it doesn't give any response. It is not a problem with any exact field because it queries well if I ask for it with less…
wakeup
  • 67
  • 7
1 2 3
…
99 100