[firebird-support] Replication of Firebird Databases (meany to one)

2013-12-06 Thread Andrew Gable
Hi all, Does anyone know any good free to use replication software. What i have is as follows I have 4-20 terminals with a database that holds all the products/ cashier ids etc in it and I want the system to sync the local database to it the server and then delete any data that his has process

Re: [firebird-support] RE: I dont know why sweep is not doing clean

2013-12-06 Thread Ann Harrison
On Fri, Dec 6, 2013 at 2:44 PM, wrote: > Hi Vlad, gstat -h result: > > Oldest transaction 371932 > > Oldest active1906983 > Oldest snapshot 1906983 > Next transaction 2696106 > > Only record versions created before transaction three hu

Re: [firebird-support] RE: I dont know why sweep is not doing clean

2013-12-06 Thread Dmitry Kuzmenko
Hello, sopranoeli! Friday, December 6, 2013, 11:44:31 PM, you wrote: syca> I do not mind the difference between "Oldest active" and "Next syca> transaction". why? you have some transaction (not read only read_committed) running for 2 days. Why auto-sweep is not running - this is another story

[firebird-support] RE: I dont know why sweep is not doing clean

2013-12-06 Thread sopranoeli
Hi Vlad, gstat -h result: Database header page information: Flags 0 Checksum12345 Generation 2834816 Page size 8192 ODS version 11.2 Oldest transaction 371932 Ol

RE: [firebird-support] I dont know why sweep is not doing clean

2013-12-06 Thread sopranoeli
Hi, thanks for your answer. I was checking the tables "MON$Attachments" and "MON$Transactions" but do not include the transaction id "Oldest Transaction". I appreciate any other suggestions to find the problem. Thank you, Vanina

Re: AW: AW: [firebird-support] difficult question

2013-12-06 Thread Tupy . . . nambá
Dear mrs.Ann, Thanks for you remembering, excuse me for losing the focus. Mr.Olaf is using almost no code in the application, he is working "data-bound". If he was using triggers, he could do it more easily yet, with generators. And he has almost no control about the lock, because he is using M

Re: AW: AW: [firebird-support] difficult question

2013-12-06 Thread Ann Harrison
Since this discussion has wandered off into German, I'm going to put this as bluntly as possible in English. Never use "select max (id) + 1 from targetTable" to create unique identifiers. It's the worst kind of bug - one that works when you test your code in single user mode, and fails unpredictab

Re: [firebird-support] Firebird v1.5.3 on Windows Server 2012

2013-12-06 Thread Ann Harrison
On Fri, Dec 6, 2013 at 10:59 AM, Softtech Support wrote: > > > I do not have time to upgrade to V2.0 or v2.5 before the new server would > be in. I fully intend to when time permits. Thus, the reason I'm asking > if it could be done to allow them to continue while I do the conversion. > > I gu

Re: [firebird-support] Firebird v1.5.3 on Windows Server 2012

2013-12-06 Thread Softtech Support
I do not have time to upgrade to V2.0 or v2.5 before the new server would be in. I fully intend to when time permits. Thus, the reason I'm asking if it could be done to allow them to continue while I do the conversion. Thanks, - Original Message - From: Konstantin Khomoutov To

Re: AW: AW: [firebird-support] difficult question

2013-12-06 Thread Tupy . . . nambá
Olaf, I glaube ich have  eine Ahnhung von was passiert. Wenn man Access brauch, wenn du bewegst von eine Linie (record) zu eine andere, Access macht sofort commit. Das heisst, wenn du clickst an eine Linie, die letze wo der Focus früher war wir sofort commited. Dan, man verliert der Kontrol de

Re: [firebird-support] Firebird v1.5.3 on Windows Server 2012

2013-12-06 Thread Konstantin Khomoutov
On Fri, 6 Dec 2013 08:33:25 -0600 "Softtech Support" wrote: > Can anyone tell be if Firebird v 1.5.3 will install and run > effectively on Windows Server 2012? > > It is currently being ran on a Windows 2003 Server and they are > wanting to upgrade to a new server and I just wanted to see if the

[firebird-support] Firebird v1.5.3 on Windows Server 2012

2013-12-06 Thread Softtech Support
Greetings All, Can anyone tell be if Firebird v 1.5.3 will install and run effectively on Windows Server 2012? It is currently being ran on a Windows 2003 Server and they are wanting to upgrade to a new server and I just wanted to see if there would be any issues. Thanks to any who can shed so

[firebird-support] Re: mon$call_stack, FK cascade

2013-12-06 Thread Dmitry Yemanov
05.12.2013 23:38, unordained wrote: > I'm using an autonomous transaction from inside my trigger to check > mon$call_stack > to see how deeply-nested my current statement is (active statement of current > transaction). Very bad idea performance wise. > Am I crazy? Do the implied triggers that h

AW: AW: [firebird-support] difficult question

2013-12-06 Thread checkmail
..sorry, Roberto of course One thing again, firebird realized in every case the ID-Generation, main-table at the time select max(nr) – will I change – and in detail-table with a generator. Hello Robert, yes, I use Microsoft Access and I have test it with different versions of it. Th

AW: AW: [firebird-support] difficult question

2013-12-06 Thread checkmail
Hello Robert, yes, I use Microsoft Access and I have test it with different versions of it. The tables are linked over odbc (Firebird ODBC 32 Bit, only select dialect 3, quoted identifiers and safe thread) and some commands (not used in this case /forms) realized with ado-db. I have sep

Re: AW: [firebird-support] difficult question

2013-12-06 Thread Tupy . . . nambá
Olaf, Du sagst, I habe ein Form und ein SubForm !!! May I ask you wich development enviroment are you using for the front-end application ? I see this kind of application building as having been built with MsAccess !!! Because I work with VB, C# and Delphi, and I found this only with the Offic

AW: AW: [firebird-support] difficult question

2013-12-06 Thread checkmail
Hello, I'm sorry, I don't know exactly how the odbd driver works. Actually I work alone on the database, no other user creates records. Microsoft Access gets the record-ID after I change the focus. Thank you. Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com

AW: [firebird-support] difficult question

2013-12-06 Thread checkmail
Hello @ll, Today, I still could not reproduce the error again. What I can say, that I’m the only one in my test environment who creates records and the error also occurred there. I can try to create a generator instead of the max-statement and I will see. Of course, several people wor