Re: [firebird-support] How do I get the differences between 2 timestamps as a timestamp.

2013-06-04 Thread Cornie van Schoor
Hi I am not sure if it is really legal and if it will always work, but this works for me for now. Period = dateadd(minute, datediff(minute, Start_Date, End_Date), cast('30.12.1899 00:00' as Timestamp)) will change the Period to Integer and save the DateDiff(minute ...) in it, when I have

Re: [firebird-support] Error dropping index after col rename - (known) bug?

2013-06-04 Thread Kjell Rilbe
Den 2013-06-03 19:45 skrev Hannes Streicher såhär: Guten Tag Kjell Rilbe, what happens if you commit after alter table ? Then it works, but I shouldn't be required to commit there, should I? And if so, shouldn't the error occur on drop index rather than on commit? Hi, This seems

[firebird-support] Re: Rename database command

2013-06-04 Thread sir_wally_lewis
Hi Ann, Thanks for your input. A problem with nbackup is transaction counts are not reset. As you know our company builds and works with databases around 800 GB. It became clear to us that to keep the system going we have to run a backup/restore every weekend because of slow downs when