Hi all, I use firebird 2.1 with Xp sp2. I have a simple table (tree) with 3 columns "Id","father" and "Description". The table is autoreference. I would like...
giuliano@...
May 1, 2008 2:27 pm
93972
... WITH RECURSIVE For example: WITH recursive ric(id,father,depth) AS ( select id, father, cast('' as varchar(255)) as depth from TREE where tree.id=1 union...
The first suggestion uses this plan: PLAN JOIN (D INDEX (I_G),DP INDEX (U_DP)) [U_DP is a unique index using on dp.N] The second suggestion uses this plan:...
Rick Debay
rdebay@...
May 1, 2008 5:36 pm
93975
I have run into some errors while trying to restore a firebird database. Firebird is running as a service. The backup worked great with the loop back in the...
... The backup file isn't a database so, to open it, you need a file path, not a database connection string. Because you're trying localhost one assumes that...
Hi. Is it possible to back up data only and not the metadata (schema)? I have several development databases that are in various states of moving forward with...
Hello, can anybody confirm, that the RemoteBindAddress config setting in Classic Server 2.1 (64 bit linux) does not work? I've correctly configured an IP and...
Hello, can anybody confirm, that the RemoteBindAddress config setting in Classic Server 2.1 (64 bit linux) does not work? I've correctly configured an IP and...
I checked the FAQs and this board and found plenty of references to accessing older servers with newer clients, but I need to go the other way. I have a large...
... look at ibdatapump or ibpump, can't remember the name exactly -- Alexandre Benson Smith Development THOR Software e Comercial Ltda Santo Andre - Sao Paulo...
hi there i have been create an international program how i should to set the charset the firebird then the countries can use it i mean as example the greece...
Hello, 1 - Is article.enabled indexed ? 2 - Is article.enabled switchable ? 0 to 1 or 1 to 0 ? 3 - If no (always 0 to 1), you could add in where clause " and ...
sql: select * from table where upper(field) = upper(?field COLLATE PXW_TURK) error: An error was found in the application program input parameters for the SQL...
hi i had have been created a fdb with 1.5 then i wantto use 2.0 and i will create a fdb with 2.0 there is on my pc the 1.5 if i install the 2.0 too do they...
... I'm curious if UTF8 incurs any significant hit for queries in general? I'm still getting used to the concepts of UTF8 personally, but I would like to use ...
... I don't think so. I'm using UTF8 in a lot of projects without any problem. Good index and good schema is better thing to deal with. :) -- Jiri {x2} Cincura...
Hi all... I use Firebird 2.1 on Xp sp2. I would like to know if is possible to use CREATE FUNCTION with a IN parameter and the result is a table, in this case...
giuliano@...
May 2, 2008 2:04 pm
93994
... No. An old client should work with a new server. It won't handle new features, of course, but neither will your old application. Regards, Ann...
... Very well ... Giuliano, Firebird is NOT MSSQL. Firebird even is not Interbase ;) Learn its PSQL language, please, before making any assumption. Regards, ...
Thanks, Guys... I'll look into both. Kurt. ... moving forward with indexes and views the main differences; I do not wish to accidentally "revert" any changes...
... Perfect. Thanks Jiri, Warm Regards, Lee "When my company started out, we were really, really, really, really small. Now...we're just really small."...
