Hi Helen Thanks for your response. I will explain what I intend to do so that you and other can help me with this. I am not totally a newbie but I am still...
... First, you can't retrieve a return value from a trigger. You can, however, get a return value from your SP. It's hard to think of how you might use it,...
I am not able to connect to FB using a local connection. A while ago I had an alert--I think it was Norton, but it may have been ZoneAlarm--something about...
... Ed, You need to be very careful about using the words Local and Remote, because it may not be what you mean. Firebird has a local protocol which has...
... It's a year since I replaced Norton on my network with Trend Micro PC-Cillin (and haven't regretted it!). I don't have a Norton admin console installed...
Hello Group, Is there a single command in Firebird to reset the statistics of every index? Failing that, is it safe to call set statistics from an execute ...
... The error message quotes a Firebird error code, so TRAK.exe was able to connect. ... In other words, TRAK.exe connected to the Firebird server, but the ...
Are there any instructions available for constructing an MSI file for installation of FB 2.0 under Windows? I want to install Firebird as part of my product. ...
Andrew Chalk írta: Are you sure you want that? The Firebird's installer is using InnoSetup that is configurable via command line. You can install it silently...
KamiHír
kamihir@...
Jan 2, 2007 8:46 am
82634
Ann, changing the subject was a good idea, as the OP must have considered solved the problem at hand and moved forward. A> So that was what was in my mind when...
Hi, is there any recomendation for "page size" for FB 2.0 ? In IB6 doc I have read : "InterBase pages are 1KB by default. A typical production InterBase ...
... No FB 1.5 (and possibly eeven arlier) default new databases to 4K unless otherwise specified, which probably answers your next question. ... Not really...
Thanks Adam, ... are you sure ? I am not able to find it somewhere (changelog.txt, whatnews.txt, release notes) ... it is documented ? ... OK ... OK, thanks ...
Can I achieve "updating statistics" by : alter index <indexname> inactive; alter index <indexname> active; In docs says "Reactivating a deactivated index...
... The Firebird Book p236 "The optional PAGE_SIZE attribute is expressed in bytes. If you omit it, it will default to 4096 bytes with isql ...." It then goes...
Thanks for the response. ... Using IBExpert (or could be IBO, but just as an example) I change the database registration 'Server' from 'Remote' to 'Local' and...
... Since Firebird, Postgres, and now (with Falcon) MySQL all have a consistent read, perhaps tools should make an accommodation to that level of consistency. ...
... Since Firebird, Postgres, and now (with Falcon) MySQL all have a consistent read, perhaps tools should make an accommodation to that level of consistency. ...
... Yes, but that is harder to do on-line than just setting the statistics. Since the index is unavailable while it's being rebuilt, the rebuild can't be done...
Hi, ... Best thing to do is to do formatting at the client side. Martijn Tonies Database Workbench - development tool for Firebird and more! Upscene...
Hi, ... When getting the database statistics, the number of pages a table occupies should give you an idea. Martijn Tonies Database Workbench - tool for...
... yep. if you were using the embedded server, cpLocal or Local would work fine, but I suspect you are using the normal client. Using remote/localhost is fine...
