[firebird-support] Re: UN and PW not defined ... error message on Windows 7 (not XP)

2012-08-07 Thread venussoftop
--- In firebird-support@yahoogroups.com, Mark Rotteveel mark@... wrote: On 4-8-2012 16:06, venussoftop wrote: Hi all I have an app that uses FireBird is being used regularly on Windows XP pretty nicely. Now when I install the same app on Windows 7 I am still able to enter data

[firebird-support] Generators, what could cause resetting generator values to some earlier version

2012-08-07 Thread Sofija Blazevski
Hello, I have a encountered a problem at client installation I've never had before, I didn't even think it would be possible. Server setup is Firebird 2.1.3 SuperServer on Windows Server 2008 Enterprise. Firebird is used on default port with no special setup. Multiple users log on the server

Re: [firebird-support] 2 BDs compair

2012-08-07 Thread Milan Babuskov
mahdoom_a wrote: I have 2 Batabase files with same stucture and almost same data. one of them was offline and other is still online,, some mistake happend now the online is not completed has all the data some of the missing data is in the other Database file. I want the changes only in

Re: [firebird-support] Generators, what could cause resetting generator values to some earlier version

2012-08-07 Thread Tomasz Tyrakowski
On 2012-08-07 16:06, Sofija Blazevski wrote: Problem is that generator values are changed (from nowhere) to some earlier version say about 15 days ago, on the other side all of the data is current. From my own (sad ;-) ) experience I'd advise to blame Firebird last, and first look through

Re: [firebird-support] Generators, what could cause resetting generator values to some earlier version

2012-08-07 Thread Sofija Blazevski
On 7.8.2012 17:10, Tomasz Tyrakowski wrote: On 2012-08-07 16:06, Sofija Blazevski wrote: Problem is that generator values are changed (from nowhere) to some earlier version say about 15 days ago, on the other side all of the data is current. From my own (sad ;-) ) experience I'd advise

Re: [firebird-support] Generators, what could cause resetting generator values to some earlier version

2012-08-07 Thread Tomasz Tyrakowski
On 2012-08-07 17:28, Sofija Blazevski wrote: We never use negative increment, and this is only client installation with such issue. Well, if you're sure negative increment of generators is impossible and the database has never got corrupted, then either that's a very curious Firebird

RE: [firebird-support] Generators, what could cause resetting generator values to some earlier version

2012-08-07 Thread bogdan
I would check the data. It seems like an old version of database . Copy, system restore ?? Regards, Bogdan From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Sofija Blazevski Sent: Tuesday, August 07, 2012 4:07 PM To:

[firebird-support] Re: REPLACE() Retaining EOF marker from BLOB

2012-08-07 Thread red_october2009
Solution found: Just chop off the last character from the BLOB to be inserted, before doing the REPLACE() Example: vCHT_TXT = SUBSTRING(:vCHT_TXT FROM 1 FOR CHAR_LENGTH(vCHT_TXT) - 1); ... Then do your REPLACE()

Re: [firebird-support] Re: REPLACE() Retaining EOF marker from BLOB

2012-08-07 Thread Mark Rotteveel
On 7-8-2012 20:34, red_october2009 wrote: Solution found: Just chop off the last character from the BLOB to be inserted, before doing the REPLACE() Example: vCHT_TXT = SUBSTRING(:vCHT_TXT FROM 1 FOR CHAR_LENGTH(vCHT_TXT) - 1); ... Then do your REPLACE() What is your Firebird version? As