... Thanks Paul: I replaced the blob declaration in my CREATE TABLE with one setting the sub type to 0 and the size to 32762. CON_IMAGE BLOB SUB_TYPE 0 SEGMENT...
... The "Segment Size" value is no longer of any real significance for modern applications, it is for support of real legacy applications (ie. ancient). A...
Hello, I have just observed, that upon the relation TEST(ID INTEGER, CODE VARCHAR(24)): 1) select * from TEST where CODE starting ''; gives all the rows - as...
Christoph, ... Since Firebird 2.0, direct/regular db connections to the security database aren't allowed anymore. -- Best Regards, Thomas Steinmaurer ...
Hi I have problem with FB2.1, I cannot connect to database, I cannot backup database, because server allways writes this text?? What does it mean, last week it...
Hi all, I run a simple query on Firebird 1.5.5: select * from tbl_party party left join tbl_person person on person.party_id = party.party_id join tbl_payment...
Note: Sorry for hijacking the other thread. My mistake! ======================================================= Hi all, I run a simple query on Firebird 1.5.5:...
Hi, ... My experience is that you should *always* keep your [INNER] JOINS first (before) your LEFT JOINS. My *guess* is that the engine do not do this for you,...
... < Snip > ... Thanks Vlad, and eveybody who responded: This works. Helen, perhaps you might mention in your excellent book that reading and writing blobs...
Hi Although I have been using Firebird for some years, it has always been with small datasets. I am now writing an application which I estimate will have about...
I have some code I have been using for quite some time to perform backups and restores using the services API. I spent the better part of the day trying to...
Guten Tag niall_scott, ... Why RC2 and not Final ? ... no you dont have to (i do not know UIB) but some reserverd words have been added , like start which...
... I didn't know Final was out. I was on the wrong site. ... Strange I have to use them with Database Workbench as well. ... Ok I'll give it a try. ... Cheers...
Hi I have come accross what I assume is a known bug in 1.5 select sum(qty),0,sum(bond),pid from otw_products where whs='' and pid=:pid group by 2,4 goes crazy...
... Firebird doesn't have this error message. Have you considered raising this problem in the IBPP forum? It looks possible that IBPP has some kind of...
... applications (ie. ... raising this problem in the IBPP forum? It looks possible that IBPP has some kind of logical error occurring when you have a blob...
Thanks Dmitry. Yes, that works. But if I put the ( select name from city order by population ) city in a procedure (ex: sp_get_citys_by_population) the list...
... As a (mainly) Delphi programmer I don't encounter this problem. I guess the interface I use (IBO) has long ago resolved the issues around the packaging of...
... Many of the service calls (and the equivalent command-line utilities), including backup, require SYSDBA or Owner login to be allowed to proceed....
... Databases. A dataset is the output of a SELECT query. ... We don't support beta versions on this list. Why aren't you using the release? In view of...
... utilities), including backup, require SYSDBA or Owner login to be allowed to proceed. Administrator authority should resolve to SYSDBA but no OS user...
Hi All, After running 10 connections (10 Apps sessions) from the same PC to the server, the next connection says: Connection rejected by remote interface...
