My understanding is that, in keeping with Interbase v6, Firebird 2.5 does not support the SQL-92 INTERVAL keyword. At least, so suggests this reference and my repeated SQLCODE -104 errors trying to get INTERVALs to work under Firebird's isql(1). How, then, do I account for the irregularities in our civil reckoning of time -- months are...
I'm running a software called Fishbowl inventory and it is running on a firebird database (Windows server 2003) at this time the fishbowl software is running extremely slow when more then one user accesses the software. I'm thinking I maybe able to speed up the application by forcing the database to run "In Memory". However I can not fin...
I'm running a software called Fishbowl inventory and it is running on a firebird database (Windows server 2003). At this time the fishbowl software is running extremely slow when more then one user accesses the software. I'm wondering if anyone could provide some information on tuning the database or best practices? We are currently runn...
I have noticed that when we use F_RoundToEven UDF from FreeAdhocUDF, that it fails to produce a correct result with certain numbers. For example, the query: select F_RoundToEven(21.145, 2) Correct, F_RoundToEven(215.145, 2) Fail from Rdb$Database produces the result: CORRECT FAIL 21.14 215.15 Obviously these two number shoul...
I have a Firebird stored procedure that accepts Decimal(9,6) values for Latitude and Longitude parameters. It's used to create a contact profile for a user. When I try to create and use these decimal parameters, I get a conversion error: Value was too large or too small for an Int32. Here's how I create the ADO.Net connection: Fb...
hi i want to use firebird library , and i followed its instruction as below , but i get "The referenced component 'FirebirdSql.Data.Firebird' could not be found." error. instruction : Prerequisites Make sure that you have Visual Studio .NET 2005 Standard or higher edition. Express editions are not supported. Registry update Reme...
I am using FirebirdSql for Interbase database in C# .net environment. My application is divided into 3 parts, 1. Handler 2. Connector 3. DBLayer In Handler I set all my fields property, Like Decimal name = payment.name; Decimal convRate = payment.ConvRate; string remark = "Some Text"; retValue = Payment.Insert(name,convRate,remar...
I want my C# program to know if the notNULL constraint is set for a specific Firebird database column. Can it be checked dynamically, perhaps by querying the meta data? I find the Firebird documentation to be very sparse. Also, how does Firebird provide information what columns exist in a specific table? ...
My tables have some inner pre-fix that users must not know. So I made a SP like this to retrieve lines. CREATE PROCEDURE p_Test ( inStation varchar(10) ) RETURNS ( ServiceName varchar(20) ) AS DECLARE VARIABLE StationTable varchar(20); BEGIN StationTable = 'TSTATION_' || Upper(Trim(inStation)); SELECT Station...
I'd like to get the ID of a particular row from within a Firebird 2.1 stored procedure. I can't seem to remember the syntax, and it's driving me nuts. This is how the code might look in TSQL, used by Microsoft SQL Server. @ID = SELECT ID FROM ADDRESS WHERE POBox = :POBOX AND ExtendedAddress = :EXTENDEDADDRESS AND ...
hi Is there anyway that I can use firebird with my winbinder standalone application? i'm developing simple windows application with winbinder and I was trying to embed firebird with my application. does anybody knows how to do this if its possible? ...
What do others do to simplify the creation of simple, serial surrogate keys populated by a SEQUENCE (a.k.a. GENERATOR) in Firebird >= 2.1? I finc the process comparatively arduous: For example, in PostgreSQL, I simply type: pg> CREATE TABLE tbl ( > id SERIAL NOT NULL PRIMARY KEY, > ... In MySQL, I simply type: my> CREATE TABL...
One of our customer has a 35 Gb database with average active connections count about 70-80. Some tables in database have more than 10M records per table. Now they have bought new server: 4 * 6 Core = 24 Cores CPU, 48 Gb RAM, 2 RAID controllers 256 Mb cache, with 8 SAS 15K HDD on each. 64bit OS. I'm wondering, what would be a fastest c...
I have a table with 6 columns: id, a, b, c, d, e. id is primary key. I am trying to retrieve distinct a, b, c, max(d) for that group, and e that is present in the same row as max(d) is (column "id" is not relevant for my query). I tried this query: SELECT a, b, c, MAX(d), e FROM tablename GROUP BY a, b, c; but it gives me "Invalid e...
Hi, Firebird 2.5.2 prints every SQL command (SELECT, ...) to Visual Studio's output window. This makes it hard to find my own debug strings. Is it possible to disable Firebird's output? Thanks, Norbert ...
Hello there, Im trying to find records in a VARCHAR column that may contain a NUL (0x00), and I cannot find a way to locate the NUL character. Any ideas are welcome. -Israel ...
Using Delphi 2009 + Firebird 2.1.3. Database is ODS 11.1, default char set is UTF8. My prepared query is as follows: SELECT a.po_id, a.po_no FROM purchase_order a WHERE EXISTS (SELECT 1 FROM sales_order_item z1 JOIN purchase_order_item z2 ON z2.so_item_id = z1.so_item_id AND z2.po_id = a...
Had a webserver crash yesterday and had to reinstall system (Ubuntu)..99% of the data/application restores were just fine as I use mysql and have proper backups, however also have 2 firebird databases which were unfortunatelly not backuped using gbak and I have only the fdb files available. Is there any way to restore Firebird database...
Hi, I am trying to backup my Firebird 2.5 database file by code: FbBackup backupSvc = new FbBackup(); backupSvc.ConnectionString = MyConnectionManager.buildConnectionString(); backupSvc.BackupFiles.Add(new FbBackupFile(backupPathFilenameAndExtension, 2048)); backupSvc.Verbose = true; backupSvc.Options = FbBackupFlags.IgnoreLimbo; back...
Hey guys, I need to check on the contents of blobs in my databases (yes, plural, but one problem at a time). In one database, I have about 900 images of potentially varying sizes. I need to check to see if the versioning system that's built into our application is actually correctly replicating the image data from the previous version...