Hi Experts,
Here's an issue i'm having. In a company with 8 machines, running Windows XP Professional. My application is running fine. Running Interbase 6. My client recently bought 3 new m...
I have a stored procedure which itself needs to call another procedure, which in turn calls itself a number of times.
The problem is that I need to be able to return all values of the retur...
We have a industry typical application that needs Firebird as backend.
From the company that created the software, it takes ages to get an answer. So i'll ask it here.
I don't think it's...
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...
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...
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 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...
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...
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...
I am using Firebird 1.5 in windows 2000 server. I use Firebird ODBC which I access in Delphi 7.
Using different sessions in my program on a firebird database, the maximum number of connect...
Good day
I am running firebird 2.00 database engine and EMS Sql manager professional. I am trying to perform some database administration tasks.
Firstly my database is growing by size ea...
I Have
Free version of Interbase 6.0 on Windows 2000 Adv Server
The problem is in the log file, this file is full with the following errors
NZON (Server) Fri May 27 14:48:23 2005
INET/ine...
How do i select Distinct on a specific column when the select statement selects multiple columns...
Example:
--------------------------------------------------------------------
booktown=...
How to use the "firebird.conf" file in Firebird to optimize the database system's performance?
I can join two table from two different databases in SQL Server:
select * from Database1..Table1
cross join DataBase2..Table2
but i can't do such work at interbase .Please help to do th...
Hi,
I have been handed a Interbase 5 GDB file to generate a sales report by developing a customised program in C#/.Net.
The passwords/userid to access the GDB has also been provided, so wa...
Hi all, I am currently stumped trying to insert text data into a BLOB field using ASP. I have had success using the following syntax with a SQL Dialect 3 database and a BLOB SUB_TYPE set to T...
Similar questions to this have appeared here before, apparently without conclusive answers, so I hope members will forgive the repetition!
Server (Win server 2003?) runs IB7.1 server (as a ...
Hi,
I am using firebird as a embedded database in c#.net desktop application.
I have SELECT and UPDATE queries of more than 100 fields for a table. It has no relations to any other table...
Hi,
I need to find out how to load documents (word, excel, openoffice, pdf, jpeg, bmp etc) into and out of firebird blob fields using Delphi (D2006). Can anyone help or point me to a good...
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...
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...
I have some tables that have a field called CREATE_DATE. I would like to set the default values for new records to the current date. How can I accomplish this?
I'm looking to move a datbase project from desktop applications (which I am vastly familiar with) to web based (not so familar). I've got my database defiend, I've got the connection where the...
are there any features analagous to access's compact and repair?
using firebird for a client side program - and getting quite large database sizes... its nearly like i'm getting the same so...
