firebird

How can I temporarily disable all constraints in a Table in Firebird 2.1?

I want to disable all Foreign key constraints and re-enable them after, is there some way to do that? I know that SQLServer allows that, but what about Firebird? ...

Firebird and IBCTable

Hello. I am trying the devart ibdac components but I am having a little issue with the IBCTable component. On tables with autoinc (trigger based) when I try to post the data it says that the field with the autoincrement must have a value, whereas if I use a SQL query to insert it everything works fine. Is there any workaround for this? ...

Tools for Performance Testing Grails Wep Applications

I am searching for an Tool to test an Grails Wep Application on a Tomcat Server. I need some Data about the Performance when 30 Users work with my app.(Creating/Editing/Deleting Entries on my Database (Firebird). ...

Values from multiple tables on a row

Hello, I have the following 3 tables Table1 ID | NAME ----------- 1 | X 2 | Y 3 | Z Table2 ID | NAME ----------- 1 | A 2 | B 3 | C Table3 ID | P (Boolean field) | Other cols 1 | True ... 2 | True.... 1 | False now I need a query on table3 that has to do the following. to display the name field of table1 and table2....

Increase in field length will result in data loss ?

Hi, If we increase the field width [say varchar(7) to varchar(20)] will it result in data loss? This is to be done in Firebird 1.5 database. Thank you. ...

How to sync my Local Firebird Database with another Firebird Database?

First of all i read this question: http://stackoverflow.com/questions/61929/firebird-database-replication But i dont want to replicate...i just want to add the data that had changed on my database to our main database. Any ideas? ...

Firebird vs HSQLDB at Java

Hi , i wanna write a small (5-6 table) desktop app in java.I wanna use Firebird 2.1. database.But i googled and see HSQLDB.I wanna make a decision between firebird and hsqldb :) So which database i have to use ? ...

Runtime Error R6034 when trying to use Firebird Server 2.1 on Windows Server 2003 (Cannot Load gds32.dll)

I'm getting this runtime error R6034 when I try to execute an application in a Windows 2003 Server. Microsoft Visual C++ Runtime Library Runtime Error! R6034 An application has made an attempt to load the C runtime library incorrectly. Please contact the application's support team for more information. This s...

Return another value when row is inexistent

Hello, In a database table with a structure like this : Table 1 Name | Id A 1 B 2 Table 2 Table1's ID | IntValue 1 11 2 66 now, there is a query which joins the 2 tables and outputs something like A | 11 B | 66 but the problem is that when, let's say row (A,1) gets deleted from table1 the...

Firebird database schema/data difference tool

RedGate makes a tool for Microsoft SQL Server that allows you to snapshot the difference between two databases. It generates the scripts needed to update the database schema while preserving the data. I need to find a tool like this for the Firebird database. We use Firebird in an embedded fashion, and would like to push out schema upd...

Views and Entity Framework

I've created a view in my database which I would like to include in my entity model. However, when I try to update the entity model through VS 2008, a warning message informs me that the TABLE OR VIEW I'm trying to add doesn't have a primary key. It seems that in order to add a view to the model, this must have a key field! How can I a...

Ways to Determine the Version of Firebird SQL?

Hi, Exist any Way to Determine the Version of Firebird SQL is running? using SQL or code (delphi, C++). Bye ...

SQL - Reference current row

Hello I have the following tables : TableA ID | SomeInt 1 55 1 66 2 77 TableB ID | OtherInt 1 ComputedBy Field 2 ComputedBy Field The computed by field needs to return the sum from tableA where TableB.ID = TableA.ID, but if I say: SELECT SUM(SomeInt) from TableA where ID = TableA.Id where the first ID would be ...

Firebird UDF creation failure

I have a firebird database that I need to recreate. It contains an external UDF function. I made an SQL dump of the DB structure using IB Expert: DECLARE EXTERNAL FUNCTION LPAD CSTRING(255), INTEGER, CSTRING(1) RETURNS CSTRING(255) FREE_IT ENTRY_POINT 'IB_UDF_lpad' MODULE_NAME 'ib_udf' However, I get an error when I run th...

Right join a table twice to a second table with each alias inner joined to to a third table's two aliases

Maybe I'm going about it the wrong way. Here is what I'm trying to do and my problem. I have 3 tables. assets (a computer, network device, etc) ports (a port on the computer, network device, etc) port_connections (has a port_id_a and port_id_b field and links each port and therefor each asset together) It's really just a way to track v...

Get count of distinct groups in a single SQL query in Firebird 1.5?

I ran across the following in a stored procedure: for select 1 from scan_queue where ( date_time_locked is null ) and ( scan_seqno >= :varMinScanSeqno ) and ( scan_seqno <= :varMaxScanSeqno ) group by loan_id, collateral_id, insurance_id into varNotUsed do varItemsToScan = varItemsToS...

Firebird .NET interoperation

Has anyone had experience with using Firebird in interoperating with the .NET framework and if so, how did it go? ...

Firebird aliases

I have developed an application using Delphi and Firebird 1.5, where the server is located on the same machine as the application. I am now deploying the application to another site, where the Firebird server (Superserver) is running on one machine (NT4) whilst the client is running on another machine. The application can connect to th...

Firebird custom installation

Hello, I want to deploy a firebird installation, and thus will launch it from my installer using command-line parameters. I read Inno Setup's documentation but still can't get it to work. I just want to install a "Super server" with no documentation or whatsoever. Here's what I have so far Firebird-2.1.2.18118_0_Win32.exe /sp- /silent...

Is Entity Framework provider for Firebird reliable enought?

Has anybody tried to use EF provider (.NET 3.5 SP1) for Firebird (embedded server in my case) in production? Can it be considered stable enough for commercial development? ...