Re: [firebird-support] Re: Crystal Report loading pblm from client ODBC
On Mon, Sep 10, 2012 at 6:22 AM, mathewabraham68007 mathewabraham68...@yahoo.in wrote: I checked with a database manager, first the view is dropped and created again, and data is retrived. but for the second time the view cannot be dropped.. My gut feeling is that CR is holding to the view and not detatching it because it's a remote database. What I would try is using a selectable stored proc instead and dropping/recreating the view in it or, even better, just not use a view and do all of the job in the stored. Please also keep in mind that, remotely, the time needed to drop and recreate a view increases because of the network latency and this might be a factor along side multiple clients requesting the same report at different, but very close, times. Regards, A
Re: [firebird-support] Re: Crystal Report loading pblm from client ODBC
Em 10/9/2012 02:22, mathewabraham68007 escreveu: I checked with a database manager, first the view is dropped and created again, and data is retrived. but for the second time the view cannot be dropped.. My first advice is to not recreate the view each time, there is no reason to do that, Use a SQL statament directly or create the view once and use it without recreating. see you !
[firebird-support] inserting special characters with insert statements
When inserting data with insert scripts containing special characters for example spanish ñ I get Invalid token. Dynamic SQL Error. SQL error code = -104. however when entering same thing though IBExpert table data interface all is OK. Field's Charset is UTF8, Collate is Unicode. how should special characters be entered though script?
[firebird-support] Migrate from 1.5 to 2.1 or 2.5: Which is the best choice?
Hi to all, I'm evaluating the choice of migrating a 1.5 Firebird database either to 2.1 or to 2.5. I've readed the release notes of both versions but I can't find no elements that help to decide which one could be best choice. I guess this depends on the database structure and the type of data stored on it, but also the client application tha uses de database. In this case, my database is a very old one that was originally used with Interbase 6.0 and the client application developped with Delphi 6.0 using Borland Database Engine (I know that BDE components must have been replaced years ago, but this is the way the application is) Now days the application is compiled with Delphi 2007 and partially migrated to dbExpress. I've tested the client application with both versions (2.1 and 2.5) and it seems to work fine. My questions are: - Is there any good reason for not migrating to 2.5 and migrate to 2.1? - Should I jump directly to 2.5, keeping in mind that SQL and data contents migrating issues could be almost the same in both versions? - Has somebody any application running Delphi BDE components using Firebird 2.5? Thank you in advance for your help. Hernando.