Stack Overflow
Stack Overflow

Questions tagged [firebird-3.0]

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

Firebird 3.0 is a previous release of the Firebird database server. The latest release is .

Notable new features

  • Unified executable
  • Improved SMP support for SuperServer
  • Encrypted wire protocol
  • Per-database configuration
  • Multiple security databases
  • Improved SQL user management
  • BOOLEAN data type
  • IDENTITY support
  • PSQL packages
  • PSQL functions
  • DDL triggers
  • SQL Window (or analytical) functions

Resources

See also

211 questions
0
votes
2 answers

Count returns different results for similar set of tables, why?

I need to count the number of times product_rec_id matches, is assigned, two or more vendor's names. For example, when a user enters sarsa and bobbie25 I should get a value count of 1 from the example vendors' table below. This is what I have and…
nDelphi
  • 45
  • 5
0
votes
1 answer

Cast function firebird

How can I convert 0 as float? Cast( 0 as float ) return singe not float? for example I have a table X with F1 field - float When use Select (cast(0 as float)) as F1 from X return error Expecting float actual: Singe.
user2531567
  • 23
  • 3
0
votes
0 answers

Connect to Firebird 3.0 embedded database in delphi

I created an application using Delphi Professional 10.1 to connect to a Firebird 3.0 database using FireDAC. I can connect without a problem if I have the FB server running. Recently, I needed to temporarily deploy the application and database to…
Terry Thompson
  • 489
  • 2
  • 15
0
votes
1 answer

Workaround for incompatible wire encryption levels in Firebird ado.net provider

I know that this question has been already asked and that one of the solutions is to change WireCrypt setting in config file. However, my application has to connect to third party software that is using Firebird 3.0 db thus I do not have the control…
RafalD
  • 3
  • 3
0
votes
1 answer

Direct connection to Firebird with IBDac/UniDac from Android using Delphi

I'm trying to connect to a REMOTE Firebird Database from Android using Delphi and IBDac. It says that cannot find libfbclient.so.3.0.2 library. I put it in the deploy to all library paths and nothing. If I remove the library it doesn't connect…
Fon
  • 33
  • 8
0
votes
1 answer

Error trying to connect a firebird database with ODBC or C# application

I'm trying to connect my c# application in a Firebird database. Using the user and password I got works on firebird sql tool. But when I go to my c# app, I got an error. So I went to the ODBC drivers, trying to connect and I got the same…
Leandro De Mello Fagundes
  • 500
  • 1
  • 8
  • 34
0
votes
1 answer

Problems generating Firebird database with script

I have a script to generate the structure of a database for Firebird and use ISQL I have problems with some of the statements I use due to the type of date TIMESTAMP, for example with the external functions: DECLARE EXTERNAL FUNCTION…
Roman345
  • 145
  • 7
0
votes
1 answer

Problems connecting firebird with .ib database (Interbase)

I have a problem and I can not connect to my .IB (Interbase) database with firebird. The case is that I have downloaded firebird 3.0 and I do not know how to connect to the interbase database I have. Do I need any more software? Normally in my…
Roman345
  • 145
  • 7
0
votes
1 answer

Tutorial on Firebird 3.0 UDFs / External Functions

Just wanted to know if anyone knows of a tutorial on how to create a udf specifically for FB3 or if the process is pretty much the same as FB2.5. I've been looking online but only can find details for FB2 and I wanted to make sure i wasn't missing…
CSharpNewb
  • 181
  • 5
  • 15
0
votes
1 answer

Firebird calc between date skip weekend

I want to convert this sql code to firebird sql for find working days between two dates: CREATE FUNCTION [dbo].fn_CountWeekDays ( @fromdate Datetime, @todate Datetime ) RETURNS TABLE AS RETURN ( SELECT (DATEDIFF(dd, @fromdate, @todate) +…
David
  • 11
  • 8
0
votes
1 answer

Connecting to Firebird 3

I have installed Firebird 3.0.1 on a PC and on a VM client. I installed Flamerobin on both to test the connection. I can connect to localhost on both PC and VM using Flamerobin, so I assume the Firebird server is running on both and Flamerobin is…
Tony
  • 48
  • 1
  • 9
0
votes
0 answers

connecting to firebird server from client

I have a problem connecting to Firebird 3 running on a Windows Server 2012 from a Windows 10 client. Firebird is running on the server and my application is ok and accesses the Firebird database on the server. However it cannot connect to the backup…
Tony
  • 48
  • 1
  • 9
0
votes
1 answer

connect to firebird via ODBC: x32 vs x64

I've installed on Win10 x64 latest firebird x64 3.0 and created database under it. I've also installed both x32 and x64 ODBC drivers. Now i've created System DSN connection via x64 driver against fbclient.dll and successfully tested it. After that…
ice
  • 44
  • 3
0
votes
1 answer

How to filter records of people who have a birthday between two dates based on their birthday using Firebird?

I would like to query in my database people who have a birthday between a start and end date. The field is stored with Date in the database, so it would need to select the anniversary disregarding the year. I tried to use functions like extract, to…
Marcoscdoni
  • 955
  • 2
  • 11
  • 31
0
votes
3 answers

How to use the return value from a stored procedure as a default value in a column?

I need to use the return value from an stored procedure in firebird 3.0 as the default value in multiple columns. My Procedure: CREATE OR ALTER PROCEDURE CURRENTTIME returns ( stime char(12)) as begin sTime = (SELECT…
Aoki.Miku
  • 37
  • 1
  • 10
1 2 3
…
14 15