I have few blob fields in my interbase database. They only store cahracter data. I want to read them along with the other normal fields so that I can export them into Excel or something. When ...
How to use the "firebird.conf" file in Firebird to optimize the database system's performance?
I have the code snippet below, where I am trying to do a backup using the Services Manager rather than starting a process. I am getting the above error where indicated.
Can someone please ...
I'm using a firebird 1.5 database and am trying to remove all dashes from a field in one of my table's. Is there a command that will do this in SQL. Like replace '-' with ''. I want all the ot...
I try to make procedure SQLScript (using Firebird 1.5, Linux) for executing multiple sql insert/update statements on low speed network.
Usage: execute procedure SQLSCRIPT('insert into aaa (1...
Firebird apparently does not have a function to find one string inside another. How do I implement this? I have the Free_UDF library (FBUDF.dll) loaded into Firebird.
Example: How would you...
Good day Experts
One of my tables in firebird 2 database are corrupt, I have tried to backup the databse but I get the following error messages.
Failed: Unsuccessful execution caused by ...
We produce an accounting system and we are presently migrating our system across to Firebird 1.54 from Interbase 5.6. We have found that at some sites on an irregular basis we get the followi...
Hi,
Firebird 2.x
Can anyone tell me if its possible to create a cursor loop in a firebird trigger? If not can it be done using a SP and calling from the trigger?
The scenario is t...
Hi,
I'm wondering if there is a way to update a table (tableA) with another table's values (tableB) where the ID's equal. For example:
TableA TableB
I...
Hi all,
I want to connect an internase database using an ODBC DSN.
i'm creating the DSN file using call for the ODBCCP32.DLL
but wen i try to connect following error occurs
i'm using
...
I have an Interbase database with two Blob-fields (sub_type 0, and sub_type 1).
Field 1 contains images (JPEG mostly), Field 2contains Text.
Now I need to retrieve the stored Images and Te...
when i want to compile stored procedure SP1 it gives me error:
This operation is not defined for system tables.
unsuccessful metadata update.
ERASE RDB$PROCEDURE_PARAMETERS failed.
inval...
Hi experts,
I have a simple question. I have a table which has fields Qty and Price.
I'm still confused which field type should i use for those fields. Decimal or Double Precision or Nume...
I am trying to access an external function in Firebird, but get this error:
invalid request BLR at offset 59
-function CALCEXPR is not defined
-module name or entrypoint could not be foun...
Hello,
I want to build a query this way
SELECT * FROM MYTABLE
WHERE YEAR_FIELD = YEAR(DATE)
Well, I don't know how to call a date from system and only extract the year from it, in M...
Is there a way for me to ignore the time of the timestamp typed field. This is my query:
SELECT Tbl.FLD_SESSIONSTART, COUNT(*)
FROM TBL_WEBSESSIONS Tbl
WHERE ((Tbl.FLD_SESSIONSTART >= '...
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'm trying yo open a GDB file in Interbase 6.0.1, but I'm not sure if I'm using the right version of Interbase cuz ti give me the follow error:
An InterBase error has occurred while attachi...
how can i parse mod(123456789012345) if mod function in firebird accept only 10 numbers
HOW TO IF IN ORACLE = TO_CHAR(IN_DATUM_POS, 'ddmmyy') DO THIS IN FIREBIRD or
SUBSTR(TO_CHAR(P.ZN...
How can I get the MONTH and YEAR from a Date field in an Interbase database (I believe it's 7)
I have a trigger for saving the changes into a history table.
For DELETE and UPDATE i use the context variable "old", and for INSERT i have to use the "new" context variable.
I want to ...
I have a problem connecting from my client machine to the firebird server using the BDE (Borland Database Engine).
The connection was working fine until I installed the Firebird Server on the...
Hello Experts,
I have been a Delphi hobbyist for a couple of years now but in all that time I have been reluctant to create programs that dealt with databases for one reason or another but ...
Hi,
I 'm using isql -page 5000 -i Controler.SQL
to run some questions in a batchfile
But now i still have to add the outputfile in the controler.sql
egg.
CONNECT "database.gdb"...
