... From where? Whatever gives 2000 identifiers to it, should be changed to do it in some more efficient manner. It's hard telling what exactly without knowing...
Hello, I have a very anoying behaviour with Firebird 2.1. Consider following select: SELECT E.BOLD_ID, E.BOLD_TYPE, E.account, E.additionalName, E.bankname,...
Thanks to all for your comments and suggestions. Our server application which is connecting to a data store (Firebird) receives these identifiers through RPC....
... Currently, temporary tables rely on the operating system keeping their contents in the file cache and not flushing to disk as long as the available cache...
I have a stored procedure without any return variable, then I alter the procedure adding an output variable. I do a backup without problems, but when I restore...
I see the problem, this SP was called by a trigger, I have added returning_values clause and the problem has been solved. I thought that the returning_values...
Well, I am about to roll out about 3000 desktops of firebird 2.1 embedded. After quite extensive testing I can state, unequivocally, that there is no apparent...
... Well, starting all over again :( All FB 2.1 binaries requires MSVC8 run-time dlls on *any* OS. All OS'es (except maybe Vista or Vista SP1) have no this...
... You forget to confirm that "cleanup mechanism for their contents" is fast, at least it is much faster then "cleanup mechanism" for permanent table's :) ...
I downloaded and installed vcredist_x86.exe http://download.microsoft.com/download/e/1/c/e1c773de-73ba-494a-a5ba-f24906ecf088/vcredist_x86.exe and everything...
In the installation program for my application, I check the user id and password for validity before attempting to see if the database already exists and...
... Of course not. If you want to know exactly what MS understands as "properly install", you may read MSDN about how to install shared assemblies. But hurry -...
... This is a known issue in FB and is registered in the tracker. ... Use FlameRobin. It detects this kind of situation when you alter the procedure and tells...
Hello, is it safe to run this bat with the Firebird (2.1) service running ? What if there is a user attached to the database? If this is not the correct way to...
... That raises my next stupid question. Is there anyplace where the services API is actually documented? I have never been able to find any API docs later...
... Which library are you using for connection to FB ? All of them encapsulate the services API, so you don't really need to use the C API from your program to...
Hi all, I'm currently working on a re-write of an existing application. In this application, I need to pull small subsets of data from a table that will have ...
... Well, your original question implied that you rely on v2.0 being installed, so you put at least some requirements to the server setup. If this is not the...
... Backing up is a frequent operation. Restoring is also frequent if the operation is done to test a valid backup and ensure restoration succeeds without...
... this ... will have ... grab say, 3,5 ... database. Because ... until end of ... necessary ... locally with ... many ... firebird, it was ... While having...
Hi. I would use a separate descending index on a date/timestamp field. And if this table has some another detail one then that detail FK should reference just...
