If Thierry is right (and that what you perceive is loss, is actually those parents that have child records), then you either have to write a stored procedure...
... Yes. It must verify user name and password. In order to do so, it must read some info from security2.fdb. For it a transaction must be started. And, as the...
... yes, it's what I thought before doing a log of the process launched: When restoring I saw a process named gbak ? ... Yes, I knew it's why I tried to assign...
... This problem is not in multicore. Gbak is just unable to connect to server using local protocol on your Windows. Find out why. I'd suggest to upgrade to...
@Svien: Like you said typing in an email client can have its problem I have updated your query where required and pasted it here below and yes, it does bring...
... If you can eliminate the possibility that somebody is trying to run gbak.exe at the same time you are invoking a restore via the Services API, then I would...
thanks for the explanation.. now... i looked at the indexes and found that the biggest one that must be reduced and, consequently, will make the procedure...
... Wich query ? Wich execution Plan ? see you ! -- Alexandre Benson Smith Development THOR Software e Comercial Ltda Santo Andre - Sao Paulo - Brazil ...
How many records are there in this table? If it is only 12, then a selectivity of 0.083333 is as good as it can be, and not the source of any slowness. In...
hi..
enclosed is procedure code i am working on...
the query plan is....
PLAN (TBRELSHAPE INDEX (FK_BRUSHID))(TBBRUSHES INDEX (RDB$PRIMARY1867))(TBRELSHUNT...
Dear all I have a many-side-table for taxation / addition / deduction records for invoices, let calls it Footer. This Footer table needs to be flattened for...
Dear Firebirds If you have not already do so, please take a moment to vote for Firebird at Sourceforge (http://sourceforge.net/cca/). We did it last year, we...
Hi again, Luis! Looking at your plans, things at first doesn't seem all too bad, but trying to look a bit closer, I certainly got a few questions. Your code...
... I finally got back to look at this problem again. For anyone that is interested... the above suggestion is quite safe because it quite simply does not work...
... Since SYSDBA is the only person who can create new accounts, I've never found it worthwhile even creating a situation where DBOWNER grants user privleges....
... This is an app with a customised security database that allows users to change their own passwords - and allows a couple of specific users to create new...
... Normal/standard setup provides for users to change their own password. So you've modified the security92).fdb to allow this I suppose. Up to you. ... I...
Hi all, I don´t know if this is the right place to post this message, but anyway there it goes... I´m having rounding issues with Delphi 2007/Zeos 6.6 and...
... But not in FB v1.5, which is where my problem application is still sitting (for lots of reasons). ... I agree entirely. I did not mean to imply that the...
... This is perfectly normal when storing decimals as floating points. Don't store exact numbers as doubles if you want exact precision. Doubles are floating...
Mark Rotteveel
Avalanche1979@...
Jul 2, 2009 7:22 am
103202
I have a delphi 5 application connect to FB 1.5.4 Super Server by IBX Component. FB Server run on Windows Server 2003. everything work fine until we upgraded...
I'm just wondering if it's allowed to have spaces in the path? I'm trying to set this in OSX using the Info.plist file with our application, for FB Classic...
heLen, Thanks for reply. I ensured that Firebird 2.0 client library (fbclient.dll) is on Client Machine (same as program folder). ... what do you mean of...
some search by google result is to check network hardware too, but I have no idea what should I check. we have no hardware changes. with FB 1.5.4 the case is...
Firebird 2.1 on Linux 64-bits. (LI-V2.1.0.17798) The last two nights during normal backup and restore of one of our databases we got segmentations faults when...
I am using "." in LSEnvironment and it works: <key>LSEnvironment</key> <dict> <key>FIREBIRD</key> <string>.</string> </dict> I put the files in the same folder...
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.
