I am trying to install the latest version of Firebird from inside InnoSetup... I get the message that the Firebird services are running and I have to stop them before continuing.
This is su...
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 ...
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...
I am running Firebird 1.5.3 on a windows2003 server with terminal services. Firebird is installed as a service. The frontend of the program is written in Delphi7. Clients connect through with ...
Hello experts!
Due to a messy import of data from another database we need an SQL statement with Firebird syntax that will update the numeric values in entire columns of specific tables by ...
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"...
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...
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 ...
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...
I am trying to connect to an Interbase-server on a server through ISQL, but can't get connected.
No problems with IBConsole, but I also want to be able to do things through ISQL.
Situation...
Hi,
I am new to firebird. Though I have been reading The Firebird Book and have used Firebird in studying. My question is how to create events in Firebird (1.5.2.4731) when a row is added i...
Hi,
We developped an application based on Interbase 7. It works
fine on developpers computers but final user cannot execute the program :
he gets this message : 'Cannot attach to password d...
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 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...
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 >= '...
Hi,
I have a network which has Windows server 2000 on a Pentium 4 3Ghz with 120GB Raid hard drives.This domain controller also has remote access enabled and has users logging in to access t...
Hi,
I am old to databases but new to Firebird! Could you help with the syntax for the following statement please :-
IF (not exists(select PlayerID from Player where Site = 'SITE' and Al...
I have this query which i use in msSql and Mysql but how would i do this with firebird?
SELECT VendorNo, Description, CONCAT(CAST(VendorNo AS CHAR), '. ', Description) AS NameAndNo FROM ven...
I have a .fdb file that is in firebird/interbase format that I need converted to mySQL (or access). I'm currently using a trial version of "Full Convert Enterprise Edition", but it's $250 and ...
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 ...
Hi,
I have a Firebird database with three fields: ID Integer, FIRSTNAME Varchar(50), LASTNAME Varchar(50).
I have created an Insert stored procedure called SP_INS_TABLE1 that reads in EM...
Is there an RDB$ table that tells me which user tables exist?
How can I check if a table already exists before I create one in a script that issues a CREATE TABLE command?
Thanks.
hello friends, I have a problem and hope u can help me.
Its probably quite easy so the point are not that high.
here we go:
(my english vacabulary is not the best but I hope youll understan...
Hello,
I had a 500 MB Size Firebird Database File with .FDB extension. i deleted all the data from the database file. even then it is showing the size of 500 MB. how to reduce the size of the...
Hi,
I use a datagridview linked to a dataset loaded by a table stored on a firebird db.
The table contains a coluimn deifne as boolean but in the datagridview vb.net displays it as textbox...
