Re: [firebird-support] Why I cannot remove FK constraint

On 1/24/2019 7:56 AM, respekt...@post.cz [firebird-support] wrote: Hello I have problem with part of our databases. All our databases should have the same structure, but in some of them I cannot drop constraint ALTER TABLE VYKONY_AUT DROP CONSTRAINT FK_VYKONY_AUT_VYKON chyba:

Re: [firebird-support] Firebird 2.5 - Data committed to database is not found after a while

Hi Also look at application logic. When invoice is commited before or after print?What is your transaction setup? Do you depend on some automatic commit/rollback or you call commit explicity? Do you use commit retaining? Regards,Karol Bieniaszewski null

Re: [firebird-support] Firebird 2.5 - Data committed to database is not found after a while

25.01.2019 17:30, duque.herna...@yahoo.com [firebird-support] wrote: > Have anyone had this situation? > > Is it posible that it is related to a Windows version? If your database file has GDB extension, Windows System Restore (including automatic one after some minor reboot errors) can

[firebird-support] Firebird 2.5 - Data committed to database is not found after a while

Hi, I have a legacy application written in Delphi XE6 using Firebird 2.5. Since several months ago have noticed that some times table records are not commited to database. I thougt that it was user mistakes with the application but not. They show me evidences that data was typed correctly:

ODP: [firebird-support] Question about delay in fetch operation

Hi. Look at gstat output You probably have very long version this particular record Regards, Karol Bieniaszewski

ODP: [firebird-support] Firebird database executing DML queries very slowly.

Hi. When you gain slowdows Run gstat -h and put here results. Problem probably is because of some long running transaction. Regards, Karol Bieniaszewski