Experts Exchange

1. NickUpson 51,975
2. dprochow... 12,500
3. rfwoolf 8,375
4. phuocnh 6,250
5. Geert_Gr... 6,000
6. pcelba 4,000
7. Sharath_... 3,575
8. Delphian 3,500
9. rrjegan17 3,300
10. aikimark 3,200
11. donald9 2,000
11. mlmcc 2,000
11. JimU 2,000
11. rockiroads 2,000
11. Compaq_... 2,000
11. dankangr 2,000
11. KeremE 2,000
11. dominik-j... 2,000
11. 60MXG 2,000
11. GiftsonDJ... 2,000
11. shrishti132 2,000
22. nfantano 1,600
23. murphey2 1,500
23. angus_y... 1,500
23. and235... 1,500
23. FVER 1,500
23. NicoJuicy 1,500
23. RiteshShah 1,500

1. NickUpson 415,281
2. kacor 51,844
3. BAlexand... 39,502
4. hobbit72 27,954
5. dprochow... 16,400
6. Stummel 15,838
7. phuocnh 13,900
8. Limbeck 13,475
9. idt 12,791
10. Delphian 10,589
11. Trekker72 9,840
12. rfwoolf 9,175
13. Geert_Gr... 9,000
14. vowca 6,618
15. ziolko 6,500
16. Deesy 6,310
17. MicheleM... 6,293
18. tkalchev 6,201
19. angelIII 6,000
19. imfallible 6,000
21. YodaMage 5,982
22. ezraa 5,922
23. thegroup 5,672
24. mlmcc 5,200
25. TheLearn... 5,100

Congratulations to DanRollins, the first member to earn 50,000 Article points! With 56 articles written, including two Editor's Choice and ten EE Approved, DanRollins is more than worthy of this honor. Keep on rollin', Dan!

Having problems asking a question? Have a general question about Experts Exchange? Let us know!

Time Tested Interbase / Firebird Solutions: 1 - 25 of 248

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

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 ...

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...

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...

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...

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...

to_date function for firebird

On Firebird which function we can use instead of to_date function on oracle.

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...

Procedure return value on vb

How I can get a procedure return value after executing procedure on vb.

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...

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 ...

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...

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, ...

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...

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.

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...

Cannot attach to password Database

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...

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.

Firebird Events usage in C#

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...

What is the Concat() equivalent for Firebird

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...

Replace string function

Hi I have a table, some of the data in which is invalid. When it was loaded from an old system it came out with two spaces in between some words instead of one. The column 'suppname' sho...

REading a blob field in the SQL

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 ...

Stored procedure: Varchar input parameter limited on 256 chars?

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...

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...