Helen: Thank you for your answer. Before doing the test suggested in the file metadata_charset.txt using isql, I made a backup and restore of each database...
Hi, I able to use to isql to extract a database metadata. However, I wish to extract only a single table's metadata (create table, index, primary key,...
... All the metadata information are stored on system tables Take a look on RDB$Relations, RDB$Relation_Fields for a quick overview how it lookslike I don't...
... Thank you for your information. I wish to extract the metadata as SQL statements. For example: Create table, create index, Create Table, ... After...
... No, there isn't - the API has no functionality for that. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database...
... There is no "API function" that return that to you. ... Yep, that's why I suggested one of the available tools, all the work is already done. ... Perhaps...
... The better way is to keep track of your changes and save the DDL statements so you can easily deploy this to a customer database. With regards, Martijn...
... My problem is this: I have a table with over 6 milions rows. In one the function in my application, I will purge all rows and re-insert new rows to the...
... If you know what table it is, why do you have to extract the metadata? With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download...
... I can't use temporary table. This is a transaction table that will persist in database. But I have a recovery option in my application to rebuild the...
Hi Folks, I have for many years now been using firebird, however I have only every used character set NONE. With the improved UTF support in Firebird 2.1, (and...
Hi, I cannot answer which program is which on a machine. However client machines can be found out. I use firebird 1.5x . the may be a more simple way for...
One of my clients is reporting the following error: Der Prozedureinsprungpunkt "fb_interpret" wurde in der DLL "fbclient.dll" nicht gefunden. Free translation:...
Hi Vlad, Thanks for the quick reply. ... Above is with my app version 2.x, I should get 3.0 out later this month which will use 2.1. ... Thanks for all this,...
Here are the statistics. Maybe these Hints are useful: - This behaviour only occurs on one single database - a second database (same metadata!) is ok - index...
Hello I am developing stored procedures that are used in queries. It looks like my test queries do not use the output of the newest version of my stored...
Christian Waldmann
Christian.Waldmann@...
Jun 3, 2009 12:31 pm
102582
I expect Ufirma to be defined with a longer field length than 2? To me, this seems like a (quite common) situation where the optimizer has to choose between...
... There is no "query result cache". Firebird's cache holds images of pages that have been visited; also (which affects you) it contains the compiled code...
... I assume you mean selectable SPs??? do you disconnect and reconnect the query client each time you modify the SP? otherwise the client will continue to use...
Hi Helen After disconnecting all users from the database, the altered stored procedure was avaliable and the result as expected. An thank you too for the hint,...
Christian Waldmann
Christian.Waldmann@...
Jun 3, 2009 1:53 pm
102586
... If you wish to debug what the server is really doing, the closest you can get is the turn your stored procedure into EXECUTE BLOCK, place all variables...
Hi, I am trying to use QLI to migrate data. However, I can't get it works in Firebird 2.1. I use QLI since Firebird 1.5 and doesn't encounter any problems. ...
Hi, I wish to write a tool to migrate a firebird database's table to another database. How can I do that using the firebird API? Must I use DSQL or I have...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
