Sorry for my English first of all. I have a problem and need help. I have a simple tool made by myself on c#. This tool makes connect to local or remote firebird server (v.2.5). And my tool can create specified .fdb file (database) somewhere on the server. Also i have a file with sql-statements (create table, triggers and so on). I wan...
When an application (Morfik FX 3 Beta) tries to open a database on a USB drive it fails with a FireBird error "Unable to open database". Move the project (and database files) to a fixed (non-USB) drive and it opens successfully. I have upgraded the FireBird installation provided with the Morfik Beta (FireBird 2.1) to the 2.5 RC2 releas...
I have table like data coming from a c++ module and I want to use this in Firebird SQL queries/stored procedure. Firebird allows hooking c++ code through UDFs. But it can return only a single value. I am planning to return xml string value from UDF, populate this in global table and use it for any use. Is this right way of doing? Are t...
I'm using Firebird 2.1, DBExpress Driver from DevArt and Delphi 2010. Some of my reports that used to work with Delphi 2006 stopped working and produced an error message indicating that "arithmetic exception, numeric overflow, or string truncation" had occurred. The error occurred at this point in my code: cds.Data := dsProvider.Data;...
I am migrating an application from Delphi 6 - IBX - Firebird 1.5 that works great to Delphi 2010 - Firebird 2.1 - UTF8 database. The problem is that if I use a TDBMemo to display data from a BLOB I get the following error: Debugger Exception Notification Project accedo.exe raised exception class EAccessViolation with message 'Ac...
In a Firebird database driven Delphi application we need to bring some data online, so we can add to our application online-reporting capabilities. Current approach is: whenever data is changed or added send them to the online server(php + mysql), if it fails, add it to the queue and try again. Then the server having the data is able to...
I am using SQL Manager Lite to try to run a DDL Create Table script. I am new to Firebird and I don't know why it isn't working. The following script... create table Contacts ( ID integer not null, FirstName varchar(64) not null, LastName varchar(64) ...
With Delphi 2006, I was using a library of User Defined Functions that was based on tbudf.pas and some functions that I added on my own. Since I am working on a payroll program, this functionality is very helpful for some common payroll concepts that might otherwise require some complex SQL. I have kept my Delphi 2006 installation and ...
Hi, I am using Firbird 2.5 for some applications. What I miss is a performance analyses tool, e.g. for Visual Studio, which shows what methods / queries have been executed over time. I am thinking of a tool like Apple's Instruments: Is there anything like this? Thanks, Norbert ...
Hi, I would like to know the better alternatives to the Delphi BDE. We have this huge application using Firebird 1.5 and BDE, and would like to consider the following alternatives: IBObjects FIBPlus The migration will involve conversion to Firebird 2.5 dialect 3. Can I get your ideas on which one is better? Your input is highly app...
I am getting to know the dbexpress firebird driver from Chau Chee-Yang (http://sites.google.com/site/dbxfirebird/) I find it hard to install because there is very little information, I succeded making a connection, but several questions arise: When using the data explorer and I want to connect to the database sends me the following erro...
Hi All! I need some help with a query - I'm using Firebird 2.1. I have a table like: RowID (primary key) | ActivityID | Duration | BilledAt 1 | 1 | 50 | 06.08.2010, 14:05:00.598 2 | 1 | 70 | 06.08.2010, 14:05:00.608 3 | 2 | 30 | 06.08.2010, 14:05:00.598 4 | 3 | 40 | 06.08.2010, 14:05:00.598 5 | 3 | 50 | 06.08.2010, 14:05:00.608 I'd...
Hi, I have a Firebird .fdb file and can open it fine. But some tables are empty, and I can open the .db files of these tables using 3rd part programs. This was not developed by me. Now I need to open a .db from a table from firebird using c#.net Some knows how to do that? I dont want to open the database, connect to it, etc, just open ...
Hi guys, it is possible to get only one row per record in a multitable query? I have this three tables: APPLES ID | APPLE ---------- 1 | RED 2 | YELLOW 3 | GREEN FARMS ID | FARM -------------------- B1 | GEORGE'S FARM B2 | JOHN'S FARM FARM_APPLES FARM | APPLE --------------- B1 | 1 B1 | 2 B1 | 3 B2 | 1 B3 |...
Why in the first case displays debit = 'null', and the second the right amount ~ SELECT o.kadastr, /* Кадастровый номер */ d.ar_inn, /* ИНН арендатора */ o.adres, /* Адрес участка */ r.name, /* ФИО арендатора */ o.pl_common, /* Общая плащад...
Is it possible to show the progress of an SQL query in Delphi? For example I have a long complicated query in Firebird and I want to show the user how much percentage of the query has already been completed by the system. Are there any class or component capable of doing this? ...
Hi I've noticed that ADO Connections to our FireBird 2.1 Server stays open. The connections are initiated from an Intraweb Application in the UserSession Unit. I use ADOConnection.Connected := False; but that does not seem to close the connection. I've also tried ADOConnection.Close;. Is there a way to ensure that an ADO Connection i...
I have converted a database from MySQL to Firebird, all tables name and field name are in lowercase, when i query the database, give me an error of table not found because firebird convert automatically the name of table in the Query in UPPERCASE letter, but my table name in database is lowercase. For query the database i'm obliged to e...
Hi For debug purposes I need to send 1 table of an existing Firebird 1.5 database to someone. In stead of sending the whole db , I want to send just the db with just this table - no triggers, no constraints. I can't copy the data to another db because it's just that that we want to check - why this one table is given troubles. I am ju...
Hello, With the demise of VistaDB (vistadb.net), I am on the look out for a good embedded database to use for my C# programming. Does anyone have any suggestions for something to use that it is simple to install along with my application? VistaDB was simple because I only had to copy 1 DLL file along with my app to get it to work. I ...