Hi everyone, I have got a problem with a corrupted Firebird 1.5 database which is about 2 GB in size. The database server ran out of disk space and due to...
Hi everyone, I have got a problem with a corrupted Firebird 1.5 database which is about 2 GB in size. The database server ran out of disk space and due to...
Hello: I have an application in Delphi which uses FireBird 2.0.1 Superserver. It is installed in an enterprise which has 8 users in a local network and 5 users...
Hello, I use FB 1.5 on a Linux Server (was tested on Windows Server too). In a stored procedure I have this statement: STDNEU = STDNEU + STUND2 + FREQUSTDNEU2;...
Walter Neumann
walter@...
Apr 1, 2009 7:51 pm
101262
Greetings All, I was just wondering if anyone else has found a way to find any record in any and all tables in a Firebird database that should not be null, but...
Hi , I thought I new this but im am stummped, I have a Domain that we have defined as Decimal(6,2) We have launched our project and started importing data...
... The 6 in decimal(6,2) is the precision. It includes the decimal digits. So the legal range is not -999,999.99 to +999,999.99 but -999,999 to +999,999 and...
... This is stored as SMALLINT with scale of 2. ... Sure, you increased the theoretical limit by the power of 4! ... Meaning DECIMAL(6,2) could store <=...
Doug, I was trying to find which of 400+ tables might contain this issue without having to manually go thru each table and do what you suggest on every field...
Greetings All, I use Database Workbench for development of my database. Upon doing a validation on my database using GFix thur Database Workbench it return...
Just in case it is needed here is the Database Statistics: Anyone see any issues with these settings under Firebird 1.5 Classic? Database header page...
Here's one I whipped up in PHP ... #!/usr/local/bin/php <?php $conn = ibase_connect("localhost:/raid/db/passport.fdb","sysdba","masterkey"); // Obtain a list...
Nigel Weeks
nweeks@...
Apr 2, 2009 4:09 am
101274
Greetings Nigel, I do not have access to PHP. Is there anyway to handle this in Database Workbench? Thanks, Mike ... From: Nigel Weeks To:...
Hmm, not without extending it's operation via some scripting, which won't be easy. If your database was accessible from the outside world, it could be scanned ...
Nigel Weeks
nweeks@...
Apr 2, 2009 4:25 am
101276
... Space ... Ouch! Is there any easy way of querying the Firebird Server for free disk space on the server when logging on from a client PC? That way we can...
... Database Workbench will issue a warning if you try to "not null" a nullable existing field. It allows you to enter a value that will be applied before ...
... Sorry, but this must be something you provide for. The database engine has no way of knowing how much disk space there is, nor how much is needed, nor...
(message didn't show up on list, sent it again) Frank, Could it be 192.168.1.100 is not available at clientside? Or, could it be you have set and left active a...
I may well be wrong, and have no possibility to try it now, but have you tried SELECT * FROM <MyTable> WHERE <MyNotNullableField> +0 is null Replace +0 with...
... Just rebuild corresponding indices. Be ready that some of corrupted indices will not be activated - if they are unique and data have duplicates. In later...
... Yes, this is correct. According to QA procedure, we sign off *binaries*. Making new binaries even from the same sources would require another QA round....
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.
