Re: Re: [firebird-support] Extract week of the year (within year)
Thanks all, i forgot about another locales like Sunday first day. I see that supporting official function in FB will be problematic then i do this in this way SELECT EXTRACT(YEAR FROM FLD_DATE), CASE WHEN EXTRACT(yearday FROM FLD_DATE)100 AND EXTRACT(WEEK FROM FLD_DATE)50 THEN 0
[firebird-support] How do I get my database back?
gbak: ERROR:validation error for column BOXNUMBER, value *** null *** gbak: ERROR: warning -- record could not be restored gbak:Exiting before completion due to errors So, at some point prior to the backup someone had added this NOT NULL column, and hadn't gone round setting the values in the
[firebird-support] Re: How do I get my database back?
24.03.2015 18:42, Tim Ward wrote: [#] Yes, well, there's then the question about how come you're allowed to get a database into such an illegal state in the first place, isn't there. I'd say this is what should be asked first. And it's no longer possible starting with FB3.0. Dmitry
Re: [firebird-support] How do I get my database back?
On Tue, Mar 24, 2015 at 11:42 AM, Tim Ward t...@telensa.com [firebird-support] firebird-support@yahoogroups.com wrote: gbak: ERROR:validation error for column BOXNUMBER, value *** null *** gbak: ERROR: warning -- record could not be restored gbak:Exiting before completion due to errors I'm
Re: [firebird-support] Re: Awaiting Garbage Collector
Hello Alexey Your presentation is an excellent work, as ever. I had wrote an article in my blog about it: https://firebird21.wordpress.com/2015/03/23/presentacion-sobre-transacciones-de-alexey-kovyazin/ You had explained very well everything and all can be easily understood. Thank you very
[firebird-support] Reminder: Scheduled maintenance for tracker.firebirdsql.org and web.firebirdsql.org servers -- Monday April 6, 2015 @ 9a (GMT - 4)
All, Changes are required to the hosts for these systems, which necessitates the outage. The outage is scheduled to last 4 hours. Sean
Re: [firebird-support] Firebird on mac
2015-03-24
Thread
Schwarze Consulting - Michael Schwarze michael.schwa...@schwarze-consulting.de [firebird-support]
Hi Felipe, I had the same issue with my first installation of firebird on Mac. Looks to me that you haven't added your user to the firebird user group; firebird seems to be quite strict in terms of security / access rights for its respective files. How to add your user depends on your OS X
Re: [firebird-support] Firebird on mac
2015-03-24
Thread
Schwarze Consulting - Michael Schwarze michael.schwa...@schwarze-consulting.de [firebird-support]
Hm...it's probably not a good idea to put your database into the system folder (/Library/...) Have you tried working in your own user directory ~? Am 24.03.2015 um 21:51 schrieb Felipe Mathais fmath...@gmail.com: WW. OH MY GODNESS!!! GSEC is run now! But, I creates a diretory
RE: [firebird-support] Extract week of the year (within year)
On Tue, 24 Mar 2015 09:23:54 +0100, Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support] firebird-support@yahoogroups.com wrote: Actually, Karol, “week within year” is not the week, Karol. 1 January could be week 53 and 31 December could be week 1. If you want to
Re: [firebird-support] Extract week of the year (within year)
=?utf-8?B?U3ZlaW4gRXJsaW5nIFR5c3bDpnI=?= svein.erling.tysv...@kreftregisteret.no [firebird-support] skrev: is possible to get week of the year within year? I see that built in functions only support ISO-8601 (or i do not know some parameter) Actually, Karol, “week within year” is not the
[firebird-support] Firebird on mac
I installed firebird 2.5 on mac, and I can’t use commands gbak, gsec, or connect using isql. I have exported variable PATH. But to use gsec -user sysdba -password masterkey for exemple, I get this message: “cannot attach to password database unable to open database” What should I do? I don’t
[firebird-support] Re: How do I get my database back?
24.03.2015 19:58, Ann Harrison wrote: The theory is that the constraints are all there, just inactive. There's no (and never was) ability to deactivate/activate constraints. It's possible only for indices backing those constraints. But obviously, it does not apply to NOT NULL constraints.
[firebird-support] Extract week of the year (within year)
Hi, is possible to get week of the year within year? I see that built in functions only support ISO-8601 (or i do not know some parameter) SELECT '2014-12-31', EXTRACT(WEEK FROM CAST('2014-12-31' AS DATE)) FROM RDB$DATABASE result is 1 but i need weeks in year -in example 53 you know when
RE: [firebird-support] Extract week of the year (within year)
is possible to get week of the year within year? I see that built in functions only support ISO-8601 (or i do not know some parameter) Actually, Karol, “week within year” is not the week, Karol. 1 January could be week 53 and 31 December could be week 1. If you want to consider 1 January