... very enlightning, thx again. ... wow..woo.. just a simple chat and you almost can see all my implementation. My Treeview implementation that cover almost...
... Others will no doubt weigh in here (one hopes! though you might have to wait until after the weekend...) The largest 2-decimal exact numeric available to...
... I think what Helen is trying to say, is that the UI should fit the data, not the data fit the UI. Right now, the Treeview may be the majority of the...
... Hello, I'm just considering the COMPUTED BY field versus SP when calculating totals, from the performance pov and also from altering structure when/if...
... Save us all a bit of time and provide details of the 'bug'. You have not said whether it does not execute, or whether it is giving you an error, or if it...
... Hi Jason, I have just produced a test case using the information you provided, and as Helen points out, Firebird correctly refuses the alter table ...
... This has been my experience. Computed fields are great for fields where the value can be calculated by the other fields in the current record even using a...
Hi all! I have to rewrite an application from Win32 to ASP.NET 2.0 and this applications uses Firebird DB. Does exist a Firebird Membership Provider class...
Hello, We have encontered into a weird problem. Some queries are like 10 times slower when Implemented as view. If query is run as is it is much faster. Is...
... The behavior depends on the type of view. Views with aggregates and grouping are harder to merge into a query than simpler views. What do your views look...
Dear All, Just thought i'm gonna share this little problem that a customer reported last friday. Took me 2 days to pinpoint the problem. In an AFTER UPDATE...
FireBird 1.5 Super Server version, Delphi 7. I try to use Delphi "Interbase" components TIBDatabase.Usernames but only can get user name. Because we need to...
... Sorry, no coconut. :-) A local variable is *just* a variable. So, like any variable, it keeps its last value until something actually changes. Where your...
... It looks like you tried to do cartesian product instead of FULL JOIN. Thay are different things, you know... -- SY, Dimitry Sibiryakov....
Dimitry Sibiryakov
SD@...
Apr 3, 2006 4:06 am
74155
... I don't think so. But if you are concerned on client security, you can accomplish the same via changing some params in inetd.conf to prevent inetd from...
Dimitry Sibiryakov
SD@...
Apr 3, 2006 4:09 am
74156
... Ouch. Had you posted here it would have been spotted. We have created an external function that wraps a call to OutputDebugString which is invaluable in...
... You will need to insert this information into a table from your program when someone 'logs in'. There are reasonably simple windows calls for this...
... The problem is that this is a rather large system. Once i made sure that the problem is in THIS particular trigger, the answer kinda popped out, after...
... Not that I am aware of, the roadmap is available of FirebirdSQL.org. ... writes ... wrong ... No that would also work, and in some ways is probably neater....
... Hi! Logically, it doesn't make sense to use outer joins in a subselect, and you should never use the table name as an alias to a table (at least not when...
... The UTF8 character set (which is introduced in Firebird 2.0) has only 2 collations: - UCS_BASIC sorts in Unicode code-point order - UNICODE sorts...
This is normal behavior. You can't select <null> into any variable, indeed, that variable holds it's previous value. The workaround for me is to use...
My customer reports that the query with date parameter always produce date format error (the error is being generated by FireBird engine). I never can...
... I always use dd-MMM-yyyy hh:nn:ss where MMM is an uppercase 3-letter-abbreviation of English month names (JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT,...
