Hello, I am getting a strange error "cannot attach to password database" intermittently. The stack trace is listed below. We are using firebird 2.1.3 with...
... Download debug kit for the same Firebird version as you used on client side. Put fbclient.pdb at the same folder as fbclient.dll. Follow instructions below...
Sorry forgot to answer your question :Â Is it happens again after Firebird restart ? I have not restarted the Firebird as the tests are running. As I have...
Greets. I wrote some code a couple years back that is getting an update into more modular/OO/reusable code. I created a base object with a DB handle that is...
... Sorry, but having 500 database connections just to please your application OO design doesn't look reasonable at all ;-) ... Connections are more or less...
Hello, I sent an identical message from an mail-client but have had no response if it had reached the group. As I am not so familiar in using newsgroups, I am...
... I would like to be able to make an general procedure that would log every (or only configured) DML operations over all or over configured tables in my...
... Thanks for the answers, I guess I'll have to think of something else, as I would like to have it as an application functionality that can be turned on and...
Hi You might be able to write a triggers for the system tables that manage the data tables layout. Upon field creation, that trigger might execute code to add...
... I've tried adding triggers to system table, it is possible. Though, I never tried how would they work as I don't know which table to use for this. I...
... They won't. Gbak doesn't look for user triggers on system tables so they're not backed up and not restored. They can be recreated after each restore if...
I am totally new to Firebird -- sorry if my questions are basic. My objective is to be able to create an application using c# in VS2008 Express Edition which...
... The Firebird documentation refers to Firebird's own componentry, not to the various host language interface layers that developers have to choose from when...
Hi I have a problem with using as parameter sub selection result f.e.: select main_table.* (select first 1 second_table.some_field from second_table where...
Piotr If you don't need check_field in yout result_set then query will look like that: select main_table.* from main_table where exists (select 1 from...
... Why do you use such strange syntax at all? Don't Sybase have JOINs? select main_table.*, second_table.some_field as check_field, third_table.some_field as...
... But isn't it rather complicated to achieve the "first 1" semantics in the OP's way using joins? How would you suggest to do that? (Not that I can't see a...
... Not so complicated if you note that original subselects don't have ORDER BY clause. ... Use aggregates. Because order is not set, MAX() will work not worse...
... Yes. Noted. Wonder what Piotr actually wanted to achieve... ... Right, works since there are no order by in the subselects. But what if there were?? But...
I sometimes have similar requirements, and typically I then do (assuming it was second_table I wanted only the first match of): select m.*, s.some_field as...
Hi, I think I have found solution to this problem for our specific case. It seems to be due to the use of multiple CPU's. From the following article it seems...
... Since you use Firebird 1.5, please note that they would be gone after backup+restore Anyway, what you would have to do is create a trigger on RDB$RELATIONS...
Hi, What's the "easiest way" to get the correct result for MOD(5.3, 2.0) from a Firebird 2.1? select mod(5.3, 2.0) from rdb$database returns 1 instead of 1.3 ...
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.
