I've written a script for MSSQL to find and replace a substring within a string in MSSQL using the REPLACE operator, but I'm struggling to do the same in Interbase because Interbase doesn't ha...
I have a table that has records that may or may not have a foreign key to another record in the same table. How do I delete the records with foreign keys if I don't know they exist? (it's li...
I am running a query to a Firebird Linked Server in SQL 2005.
I am trying to run a where clause that returns all the records that are equal to 'current_date'.
my issue is that the date fie...
Hi all,
I am using Interbase 6 and 7.I can reproduce the problem in both versions of IB
I have columns of data type TIMESTAMP.
I have a java program for inserting records, it seems that...
Hi there
We are using Interbase 5.5.
Since the beginning of this month the database just dies abnormally.
It happened again this morning (about 30 minutes ago).
When this happens nobo...
Hello,
I'm running an application which uses Firebird 1.5.1 for Windows. I have found in a reference, that there is an "if exists" function that could quickly let me know if a record exists...
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...
Hi
Whilst a server was running it ran out of diskspace, and now my application is saying this
[FbException (0x80004005): database file appears corrupt () bad checksum
Checksum error on ...
is there a way to create an array of some domain ? the domain would have a few fields like:
TKnjizba = record
RecID: Integer;
Kolicina: Double;
Cena: Double;
Vrednost: Double;
...
Just installed Firebird ODBC driver 1.2.0 on Windows XP Pro Sp2 laptop without a Firebird Server.
An trying to open a Firebird Database thru Excel 2000 using MSQUERY and Firebird/Interbase ...
I have a user of my program (that uses Firebird) who is getting the above error when starting my program. She tells me that she has two instances of SQL Server running. Do they "play nice" t...
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 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...
I have a software that uses Borland interbase 7.1 as its database engine. But in windows vista the interbase does not work properly. In the interbase manager, when I switch off the option "Run...
I have setup an IIS web server on Windows Server 2000 and have installed an Interbase server on it. Could someone help me out with the settings I need to make to the server/client in order to ...
Hi Xperts,
I'm having an SP which do
SELECT * from TBL_NOTE Where Note_ID = 1 FOR UPDATE WITH LOCK
and even I lock the record, I need to just read the entire table just to display its ...
Hey all,
I need to update the table Spelare and field Lon, but to get the result I want I need information from the tables Division and Lag as well.
Everything works fine with the two fi...
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,
i want to install firebird server on remote computer (not on other lan computer). Firebird database server would be in one town and my client program connect through Internet to it. I ...
Hey Everyone,
I have username and password for a remote Interbase DB and which I would like to access from my machine and import the data for some purpose. How can I go for it? Could you s...
Hi Experts
I'm not sure if this is the right forum to be asking this in, but I thought it looked the most appropriate. I've used a query similar to this successfully in MySQL, but I've been...
Good day
How can I get a list of all current connected users.
Thank you
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...
I have a user that is trying to run a program that uses 32-bit Firebird on a Vista 64-bit machine.
Will this work? It doesn't appear to... the program is getting the following error messag...
I've got an application i'm porting from access - adn in access i had a datetime field that i store data of this format: 5/28/2005 9:28:52 PM
in access - that gets stored as a datetime typ...
