... Using .* is bad practice, you should list just the columns you need when building the query. SELECT TABLE1.ID , TABLE1.F1 , TABLE1.F2 , TABLE1.F3 ,...
... functions ... 80 ... Helen, wasn't that issue worked around by declaring CSTRING(32767) instead of CSTRING(80), as reported on sourceforge.firebird-devel, ...
I got it working except the Create View statements are missing. For example, my view named KPI is only showing the following statements: SELECT codetable.id,...
... Sure, it works around the problem, but it doesn't fix the bug. There is a ton of UDFs out there that pass CSTRING(80) in the continued expectation that...
Can I get any feedback from this forum ? I would like to know whether the error message below means database corruption ? as I would like to prepare corrective...
Could you please point out any commercial tools that you can recommend? Thanks again... ... can ... said he ... concluding with ... infrequent ... scenario, as...
... I've only struck something like this once - quite a while ago, but since noone else is offering I suggest you make a new shell of the database, then pump...
Hi, RD> Another thing I do when I need large searchable varchars it to have RD> second OCTETS field. Each time I insert or update a string in the field, RD> I...
Hello HB> The reason this query won't use the index is that the second search HB> condition requires an unindexed read. By including it, you are obviating HB>...
-b is used to boost priority (start the process with process priority High instead of Normal). -r is used to start as Normal, but isn't that the default...
Hello, On Fri, 02 Jan 2004 22:19:13 +0700, ... Yeah, those options are not well thought-out. Offering the -b mode is even not a very good idea (on Win32 at...
... What did you have in mind? ... Hmm, this sounds a rather suspect thing to be searching on. I pass. ... You are passing the whole search argument as a...
... Olivier Mascia ... I'm with Olivier on this one, in part because I consider arrays to be a useful and distinctive feature - maybe they'll be the next...
... Firebird stores only the computational part of the view in rdb$view source. The "create view" part is, in its opinion, syntactic sugar because the...
Happy New Year! I have a problem with Firebird 1.03 SS stability on RedHat 7.2, PHP 4.3.4 (compiled with interbase shared support) and Apache 1.3. The server...
... Yes, the only case I think of where this will help is when there is an above-Normal process which hogs CPU, which should be rare. (Btw, I hate the Win2k...
Currently, in FB, when a client (client #1) updates a row (and still hasn't finished his transaction), then client #2 which tries to update the same row will...
Dear firebird-support, I recently came across a case where i thought a 'BEFORE COMMIT' trigger would be nice, and I'm wondering what is the firebird-ish way...
... A good place to start might be to subscribe to the firebird-php list and ask your question there. mailto:firebird-php-subscribe@yahoogroups.com /heLen...
The granularity of information may be at the field level, but the granularity of changes is generally limited to the row level. It is assumed that if you say...
Hello, On Sun, 04 Jan 2004 18:32:20 +0700, ... This assumption would mean #2 read the updated value of #1 (or the reverse) or that you have an kind of atomic...
David, I may well be completely off track... D> Suppose the update by client #1 is increasing the value of a numeric D> field by 1 (e.g. 5 becomes 6). And the...
