Hello, I'm having a problem with remote access to a UDF using the latest Firebird. I *can* access FreeUDFLib.dll functions both remotely (referring to the ip...
Hello all . . . I'm new to Firebird but am having installation trouble and found this e-group. I searched around for a fix but couldn't find anything, so I...
Hi When i submit some SPs i get these strange plan-warnings, f.x. : INFO: Warning: SubOptimal Query Line 6 Column 7 - May not use Index (PLAN (T_ENTRIES...
Hello, I downloaded FB 1.5.0.4290 SS for Linux and attempted to install it. The install failed, apparently because FB was built for 686-based platforms, and I...
Hi Another question regarding memory use..... I have a server running Windows 2000 SP4 all updates installed, 1 Gb RAM, Xeon 3 GHz, 2 x SCA 18 Gb HDD (as...
Hi ! I have a gdb with 277 MB size. I use windows clients, and development client, and Debian Sarge server with my own compiled FB (not deb installed version...
Hi I have a server running Windows 2000 SP4 all updates installed, 1 Gb RAM, Xeon 3 GHz, 2 x SCA 18 Gb HDD (as mirror) on a Adaptec 2110s. On this machine a...
Hi! I noticed that FB 1.5 added UDF dependencies. That is, if I try to drop a UDF that's being used somewhere, it doesn't work, whereas in IB 6.0 it does. I...
Hi, I have 2 tables: OLD_USERS, USERS. The table(s) ordinarily store user records, but can also store templates for users. Someone in the past had the bad idea...
Hi, In one of my main database I have the following values in the statistic: Database header page information: Flags 0 Checksum 12345 Generation 120993 ...
Hi: I use Firebird 1.5 running over Windows 2000 Server(2GB RAM) with a single database. The database contains information for an application of transports...
Hi, I have got a little problem with the following code in one of my stored procedures: [...] FOR SELECT ID FROM T_Privilege_Type INTO L_TYP_ID DO BEGIN /*...
Hi, A few weeks ago, I posted already a question about this subject. Problem is we had a database under dialect 1. We changed it to dialect 3. For some...
I have a stored procedure like this create procedure ProcedName ( ID integer) returns ( Number integer) ..... for select Field1, Field2 from table Where Field3...
Hi, [Firebird 1.5 CS/linux build 4290] We are working on an multi-threaded application under linux (embedded). Different threads do open a connection to the...
Hi There IB 6 has a problem with slow connection to the server. Does firebird 1.5 also introduce this problem and can you accesss it with the bde. Thanks in...
Hi there, I'm trying to add the TRIM function to my database: DECLARE EXTERNAL FUNCTION trim CSTRING(256) RETURNS CHAR (80) FREE_IT ENTRY_POINT 'fn_trim'...
Any body knows how the Vulcan projects is doing?, I keep checking the IB Phoenix pages and there is no information. This project seems very interesting but...
Hi, as there's no 1.5er release of fb for Solaris I still use the old 1.0 version. But now I've found a problem which I've to solve: The messages. Can I use a...
Hi All, I have to provide an export feature which will output all tables and all data to CSV files (one for each table). Is it possible to create text files...
Hi to all suscribers, this is my first message in this list :) I have a problem with my firebird Installation. I have Firebird CS 1.0.3 on Debian Linux. The...
Hello, While executing a procedure (from .Net application), I am getting follwing error "message length error (encountered 0, expected 8)" The same SP when...
Hi, What is the syntax for a select distinct query? I have a table that contains shift information. I want a query that will return me the shift number and...
I currently have a procedure that has 6 passed parameters. I am evaluating all 6 of these parameters to determine if they qualify for the process. If they do...
Hi I am still trying to find a way to host secure and unsecure databases on one machine. The unsecure databases uses the SYSDBA/masterkey combination. Can I ...
I need to join two tables together and get the latest date in a column in the right table for every record in the left table My attempt was this sql: SELECT...
I'm just evaluating FB 1.5 and FIBPlus for an upcoming product I must develop. Now I see three very serious problem with this combination, which makes it...
