Hi i get this error (SQL Server Error: Invalid request BLR at offset 1015 column OBJID is not defined in table RDB$PAGES) when trying to execute query in delphi using TSQLQuery. Have anyone ex...
I have a .GDB database which i want to transfer to Excel. I dont have Interbase installed and I dont have any knowledge of Interbase.
Hi,
I've several tables linked by foreign keys with Delete Rule restricted.
When I call a stored procedure within a transaction I delete the recors of the child tables first and when I delet...
Whenever I try to run the interbase commands gfix or gbak in a command window against a database on a w2k3 server, I get the message "unavailable database".
The database exists, Interbase i...
I have a client who has an old Delphi developed app (10 years Old) sitting on a windows 2000 server which is dying (and is very very slow) The database is apx 20mb in size. We have a new serv...
I've ported my Paradox database to Firebird and some instructions recommended that I make all Boolean fields a
DOMAIN called T_YESNO of type CHAR.
But how does thie help solve the problem...
I'm running Firebird 2.1.1 & my applicaton written in .net 2.0
I've become unstuck when trying to write a stored procedure to copy some blob data (a tiff image) from one table to another. For...
I'm trying to break apart a multipage tiff and have each page inserted into a firebird db as a separate blob for each page.
I've found examples of how to loop through each page of the tiff...
I have a Delphi application using Interbase component to access a Firebird database
I currently use the gds32.dll of Firebird 1.5 (but the database, located on a "server" is in Firebird 2.1 v...
This question is pretty much straightforward:
In MSSQL2005 this works like a charm:
select :CountResultParam = count(*) from MyTable where iID = :iIDparam
It stores the value in my par...
Hello,
we am using firebird as our database sever. we have one table having binary field, in which we are storing English and arabic text.
what our problem is when we are searching for the...
We're trying to obtain the foreign keys for our Firebird database, but are having a bit of trouble finding the right SQL statement to do so. Our last attempt is added below.
We have opened...
I have installed a Firebird superserver on a machine
I plan to write a client application running on other networked machines that will need to access the Firebird database
The application ...
I have a form with a DevExpress cxGridDBTableView whose DataController is connected to a TIBOQuery. When returning large resultsets, >2000 records, we're noticing a significant time lag for th...
Is it possible to have Interbase 5.5 and Firebird 2.0 installed at the same machine ? so that I could toggle between them when I want to use Interbase 5.5 or toggle again when I need Firebird ...
We have a database that continually grows and in the process, sufferers a performance hit once it gets a little big. We found that every 3 or 4 weeks there is a pressing need to stop the datab...
I am trying to summarize a field, using the SQL statement below. I keep getting the error from Firebird Maestro -> "Dynamic SQL Error expression evaluation not supported."
Why?
Hi Experts,
I have a database application in Delphi 6 with Firebird 1.5 backend. This is the required behavior.
Whenever an administrator creates a record, he will assign the clients (All or...
I would like to use InnoSetup to replace the older version 2.0.x with the newer version 2.1.1. How can I tell if 2.1.1 is already installed?
We have a Firebird v1.5 database that lives under a manufacturing program. I believe this program is not storing numeric values correctly, but the software creator doesn't seem to think so, a...
I have tried and tried... I have two XP machines; same Firebird software on both (SuperServer)... have made the folder on Machine 2 (where the database resides) sharable. My connection string...
I'm moving from a Paradox database and the BDE to FireBird. My application has a data module with dozens of TTables and TDatasources and that's all it's needed with BDE.
But with FireBird and...
In order to demonstrate a Firebird database application, I want to run the database server and the application from a USB key. How can I do that?
We're using Firebird 1.0.3, but newer Fireb...
I have the following gbak parameters that cause the following error:
C:\Program Files\Firebird\bin>gbak -REP -user sysdba -pass prager "E:\Downloads\
Email Attachments\20081021.gbk" c:\Pra...
My office runs a homegrown program that runs the POS at our stores, our accounting, our inventory, shipping/receiving, etc. This database runs using Firebird database 2.1 as the database engi...
