... Lucky you! The only think ... check the User Account Control, I had to disable it to get my delphi-firebird application work. Also check with this command:...
Hello. I have created a simple procedure just raising an exception. ... SET TERM ^ ; CREATE PROCEDURE PRUEBA AS begin exception ex_prueba; /* = 'test message'...
The intent of the "backup app" is simply to make it a bit harder for the average user to "get into" the database. Our complete software "suite" gets installed...
Hi all, I built an application that stores various kinds of resources in a Firebird database. I have a set of tables that describes each resource (be it...
lele@...
Mar 1, 2007 2:31 pm
84409
hello guys! i am contacting you because i have a very very big problem. i am migrating a database from mysql to fb2, to use it in delphi 7 pro the components...
Hi lele Pls give us more details … What FB are u using (1.5,2.0), PageSize for db (4096,8192,16384). Regards, Paul From: firebird-support@yahoogroups.com...
Congratulations ! Any thing new about Control Panel? Frank ________________________________ From: firebird-support@yahoogroups.com ...
Gonzalez, Frank (ED)
FGonzalez@...
Mar 1, 2007 4:45 pm
84413
2.0 plan is forty times slower than 1.5 plan. Would this be a case where it's a good idea to have compound keys? I think the problem is that 2.0 doesn't know...
Rick Debay
rdebay@...
Mar 1, 2007 5:13 pm
84414
Hi Thierry, For you first problem, you could do like this: Update Mytable set qty=qty - Avalue; Delete Mytable Where qty = 0; and include these 2 queries into...
When I use FlameRobin to pull up the DDL on my FB DB, I notice that there are triggers on tables that I did not explicitly create. They have names like...
Here is the code. PD_ID is the Key for the table and PARENT_PD is the parent id for the PD_ID key. If the record is a parent, then PARENT_PD = -1. Thanks for...
Anyone know why emails are randomly in traditional or new format? ... From: Yahoo! Groups Notification [mailto:notify@yahoogroups.com] Sent: Thursday, March...
Rick Debay
rdebay@...
Mar 1, 2007 8:47 pm
84419
Hello! Our company has had web application for like 5 years running on firebird - no problems at all(one time I had a bad plan with left join =D). Thanks,...
Hi, I am trying to migrate from IB6.0 to FB2.0 on Windows platform. Is there any windows-GUI admin tool available for FB2.0? Can you recommend a few good, and...
Nobuya, ... there ... good, ... home ... What, are you trying to start a "religious war"?!?!?! ;-) While my firm does use one admin tool, I think it is safe...
Sean, Thank you for the response. I know what you mean but I needed the staring point. Actually, before I posted this, I downloaded one of the admin tools ...
Hi Tom! Is there a question somewhere, or did you just want to show us some code that should get some records from pd_list and the topmost parent for each of...
Because Yahoo sucks ;) Seriously, I had the same problem for a few weeks. It didn't go away until I used Yahoo's "collect other subscriptions" feature. Then ...
... As Dmitry wrote, those are triggers for check constraints. However, they should not be shown. Could you tell us the versions of Firebird, FlameRobin and...
... You already have user RRZE in your database (i.e. RRZE is owner of some objects, or RRZE has granted some rights), try SELECT * FROM RDB$USER_PRIVILEGES...
Try in 2.0 to backup & restore the database, after try to drop all indexes and create again, test the query ( but do not force the old plan ). If you have the...
Dragos Hilbert
dragos.hilbert@...
Mar 2, 2007 3:32 pm
84429
Hi there, I have an INVOICES table like this: create table INVOICES ( NUMBER integer, CUSTOMER integer, INVOICETOTAL numeric(10,2), ...more fields... ) I set...
... there any ... good, ... IBPhoenix home page. I appreciate personal recommendations from real users. I use FlameRobin (opensource) and only reason is I...
Hello: We were using Embedded Firebird 1.5.2.4731 to create databases Now, we have upgraded it to 2.0.1.12810 The application is C# app using ado.net drivers...
I'm surprised that the index isn't picked up. Though I normally use single field indexes myself, it should be able to pick up the first half of the index in...
Hi Paul, sorry for breaking the thread, but strangely neither my original message nor your reply ever reached my mailbox, like all other fb-support messages...
