Hi, I have an application using fbembed.dll to restore database service. The restore progress run fine and I can get the restore messages on the following...
We use FireBird 2.0.0 superserver with forced writes enabled. Hardware is a HP Server with RAID 1 disks running Windows Server 2003. We acces the database...
Am I trying the impossible? I created a minimal test case. We have 3 simple tables: create table t1 ( a integer, b integer, c integer ); create table t2...
Hi. It's actually a high-level architectural question. Download Interbase and Firebird Developr Magezine issues 2 and 3 from www.ibdeveloper.com and read...
... This looks quite weird. Did you create that index named RDBPRIMARY2 ? Are you able to drop that index? (I suspect that someone has been meddling with...
Today one of my customers had a checksum error on a production database: database file appears corrupt () bad checksum checksum error on database page 62220 ...
Hi I tryi nstall fb with this step 1. Uncompress to c:\FB 2. Add up to path in Enviroment variable 3. excute install_super.bat get rror : The system cannot...
Hi Helen, ... The RDB$PRIMARY2 is the primary key of another table (CCP_ARBOLPRODUCTOS) which was not affected by this problem. I believe SHOW INDICES shows...
... Your problem is that you are a newbie trying to work with an alpha. Get rid of it and install a release version (Fb 2.0.1 or 1.5.4), following the...
... ah, ok. ... Indeed. As an ODS 10 or higher database, its NUMERIC(18,0) fields are stored as 64-bit integers (BIGINT is an alias for NUMERIC(18,0)). ... ...
Hi helen in last in some times i work ver 1.5 to 2.01 but i dont agree you i do it step by step from instruction : install_windows_manually.txt then I dont...
Hi Helen, ... Data in the VARCHAR(100) should not contain accented characters, but it might contain Ñ. Don't know if that is a problem. ... Ok. We'll do that....
... Anticipate problems with charset NONE and accented characters. ... Yes. ... No. You don't set collation at database level. All characters in a character...
Let me rephrase the question. I am familiar with other dialects of SQL, such as T-SQL, PL/SQL, and FoxPro. In T-SQL, for example, I can bring up an IDE such as...
... No, it's not true. Here's the full scoop on checksums. Once upon a time, in a cute little town called Groton, there was a database and to be extra safe,...
Hi, SELECT c.clntid, c.surname, c.forename, c.title, c.siteid, c.email , co.compname FROM Client c JOIN Site s ON c.siteid=s.siteid JOIN Company co ON...
Hello to everybody. I have a tree-like "folder structure" table, and each folder contains many rows stored in another table. Now I need to look for all the...
... Is there a file called Microsoft.VC80.CRT.manifest in the Firebird bin directory? -- Best Regards, Thomas Steinmaurer LogManager Series - Logging/Auditing...
... Fulvio> Here is the question: is it possible to have a recursive Fulvio> selectable stored procedure? In case it is possible, is Fulvio> there an example...
Lele Gaifax
lele@...
Jun 1, 2007 8:49 pm
86491
... 561K skills, 84k clients, 31k sites, 26k companies - that's a pretty big catchment for a 4-way join, so there's a stronger than usual need to keep the...
... This is a utility interface, similar in some ways to isql, not a "dialect" of SQL. ... is Oracle's vendor-specific procedural language extensions, not a ...
Hi For database design I use IB Expert personal and for debug EMS - SQL Manager lite. This combination is 'no cost'. If u debug a procedure all variables...
Why use both the postcode and primary key indexes for site in your plan? I suspect you would get far better performance by changing to WHERE ((s.POSTCODE||''...
Sorry for answering a bit late, I was put off by crossposting to several lists (that's bad netiquette). Seeing the answers in several lists, I'm surprised that...
