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 ... with my own compiled FB (not deb installed version !). Okay, you are using linux as server... ... C:\dev\BHA\database\mpanni2.gbk How can you backup a...
Hello! ... Your database is corrupted - some record has lenght different from declared in RDB$FORMATS. Usually fixing such error requires some special...
... Not exactly...but you can do this. Let's say you have the original definition for RTRIM, as follows: DECLARE EXTERNAL FUNCTION rtrim CSTRING(80) RETURNS...
... Not bad. But in my case, renaming the function is not an option, since I have an application in which I backup the DB from the IB 5 db, and restore it...
... Use the tar ball instead - and run the INSTALL script I had the same problem. The install script is fine. I don't understand the architecture mimatch...
Hi This night I did a backup - restore. Problem solved. Before I did this backup - restore I took a cop y of my "bad" DB. SO now I should be able to locate the...
... Yes, I use linux as server, but I use local windows server in my dev. client - to not load the central linux server/ and for code development. ... This...
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...
... "Release Candidate" means "beta version". There were 8 Release Candidates for Fb 1.5, before the release finally came out. You are looking at nearly a...
Hi, ... ALTER TABLE yourtable ALTER yourcolumn TYPE VarChar(newlength) ... Why IBConsole? It's not Firebird specific and there are much better alternatives. ...
... Helen answered this one a couple of weeks back when I was pondering the exact same situation. The extra memory is getting used by the windows system cache,...
Gary Benade
hobbit@...
Jul 1, 2004 2:19 pm
44140
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...
... Are you declaring the udf to your database? Are you sure you are using the FreeUDF lib functions and not the internal server functions for say SUBSTRING? ...
... Hi Dan, I had the same error on monday :-) I just downloaded the .tar.gz file and installed it... Works ok for me... see you ! -- Alexandre Benson Smith ...
... I had already re-compiled and installed using make install before reading Alan McDonald's post about the tar.gz file method, and it seems to be running...
Arno - Thanks for the advice, but this does not work. I get the sql hourglass and windows task manager shows cpu at 100% with ibexpert not responding. All I...
alan davies
Alan.Davies@...
Jul 1, 2004 7:41 pm
44145
Hi Alan, ... Try this one: DELETE FROM Supplier s1 WHERE RecordID <> (SELECT Min(RecordID) FROM Supplier s2 WHERE s2.Weigh_Code = s1.Weigh_Code) you could...
Hi, ... It should work, but while you did not had a index on Weigh_Code (as Alexandre already suggested) it was probably damn slow :-) Prepare first the query...
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...
... Hi Rasmus, It's just a hint given by Marathon. If you create the same procedure in ISQL you will ot get any warning. ... When you create a PK, an index is...
Hi I have a program written in Delphi 5 using DBISAM ver 3.27 and I want to change to Firebird. I have down loaded Firebird 1.5.0.4290 for win32 with the exe...
... I think you have alrady asked this question - but.. Firebird does not come with components for delphi. You need third party components e.g. IBO, or use...
Hi Allan, You can use the interbase components that come with Delphi to access firebird / interbase. A better solution would probably be to use the ibobjects...
... Hmmm. I can reproduce the problem with the installer. (When it tries to start the guardian at the end of the install session.) However, on Win2k at least,...
Paul Reeves
paul@...
Jul 2, 2004 5:54 am
44154
Hi, You can't use a UDF remotely! Copy the libary (DLL) to the UDF directory of fb installation or to any other path, set up in firebird.conf. r> I'm having a...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
