Advertisement

900 organizations, including eBay, Ericsson and Lockheed Martin, now work smarter with Corporate Accounts. Save up to 42%!

 
MHenry

Welcome! If you have any general questions about Experts Exchange, feel free to ask me.

 
Time Tested Interbase / Firebird Solutions: 1 - 25 of 247
 
Calculate Age from Date of birth
I have a table that contains a date of birth field - I now want to create a view that has the age based on current date - date of birth How do I do this? Thanks Anthony
Insert Into Blob field
I am trying to insert records into a table using the SQL syntax: INSERT INTO TABLE(Field list) VALUES(Value list). My code is choking on the BLOB field. I get the error: SQLState: HY000 Na...
Procedure return value on vb
How I can get a procedure return value after executing procedure on vb.
Resetting SYSDBA password.
Hey Everyone, I am running a Linux server and using InterBase 6.0. I've lost my SYSDBA password and I can use some help about how to reset the same. Is there any tool or command as such to ...
The system could not find the environment option that was entered Error
Hi, I am trying to install Firebird 1.5.2 onto one of the users machines in our office and although the install appears to go perfectly whenever i try to connect to the database i get the e...
HOW TO CAST a CHAR to INTEGER OR SMALLINT
I Store some small values in a single CHAR column. When i retrive these char values in my C# code I can easily convert them to numerical values. I have to perform some operation on the char...
Reading/Writing BLOB fields
Hi all, I've been struggling with this problem for some time, and thought the IB gurus here may be able to assist. Basically, I have a table in an Interbase 6 database that contains two ...
Connect to Firebird (.gdb) database with Access or VB 2005
I need to attach to a .GDB database for the purpose of creating custom reports. I've attached to other databases before but just can't quite figure out how to do it for Firebird. I've googled ...
Select Top 5 from Table
How do you select the Top n records in a query or Stored Procedure. my current Stored Procedure is as follows: create Procedure nspTopDTMAchines (TopRecords Integer) Returns (MachineNam...
to_date function for firebird
On Firebird which function we can use instead of to_date function on oracle.
timestamp with java
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...
Limitation of BLOB size?
hi, I have a BLOB field in one of my table. Below is the script I use to create the DB: CREATE TABLE FILES ( FILEID INTEGER NOT NULL, BIN_DATA BLOB SUB_TYPE 0 SEGMENT SIZE 65536, FILENAME...
Getting Firebird embedded working in java
I am trying to get my java application to connect to a firebird embedded database and so far i keep getting errors currently i am getting this error org.firebirdsql.gds.impl.jni.InternalErr...
General SQL error. Error reading data from the connection.
Hello all. We have a problem that we've been working on with a client for several months that we cannot resolve.  The environment is as follows. Server (not sure of server details, but a...
Insert and Select statement into Interbase database
I have a working select statement. When I add the select statement to the insert statement, it gets a general SQL error "Select". Insert into table(col1,col2,col3.....) values(Select st...
Stored procedures in Firebird/Interbase
Hi, I've been using MS Access for 2 years as the database in my VB.NET applications. I've decided now to use Firebird or Interbase. Can someone provide me with code to build and use, ...
Create Database Problem with IBExpert / Firebird Interbase 1.5, unavailable database
Hello Interbase Experts, On the PROD machine, due to management decision, we ended up replacing database server from Interbase 7.5 to Firebird Interbase 1.5. We stopped the IB 75 Guardia...
Formate Date as yyyy/mm/dd in select statement with Firebird 2
Good day, I need to do a select statement where I can format a Date Field to a string field in the format of yyyy/mm/dd. I have created a work table where I insert values into, my work t...
ODBC interbase
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 ...
Strip characters from a field using SQL
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...
Get Month and Year from date field...
How can I get the MONTH and YEAR from a Date field in an Interbase database  (I believe it's 7)
String Function in Interbase
Hello, Does interbase has string functions? Looking for something like : select left (myvar,10) or select substring(myvar,2,5) Thanks a lot, Tanya.
Unable to complete network request to host  "localhost" when connecting to interbase server
I get this error when connecting to an interbase server program.  It started happening after a reboot of the server that runs interbase.  This reboot was done because of windows updates.
Update multiple rows from another table where ID's equal
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...
Problem with gds32.dll (Delphi - Interbase - Firebird)
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...