RE: [firebird-support] Round - quarter hour

Round(100/15.00) * 15 Or (div(100,15)*15) + (cast((mod(100,15)/15.00) as Integer)*15) From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of checkmail Sent: Tuesday, April 8, 2014 8:55 AM To: firebird-support@yahoogroups.com Subject:

AW: [firebird-support] Round - quarter hour

Thank you very much!! Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Im Auftrag von Bogdan Mihalache Gesendet: Dienstag, 8. April 2014 08:05 An: firebird-support@yahoogroups.com Betreff: RE: [firebird-support] Round - quarter hour Round(100/15.00) * 15

[firebird-support] Strange behaviour error writing data to connection - but after some time connection is back.

Hi guys, I have problems which I can not explain, nor do I know how to solve it. We have FB 2.5.2 classic on linux. We have like 60 Databases there. From time to time, we can not connect to few of the databases. Simply, when we try to connect, a connection process is hanging (regardles of

[firebird-support] Re: Strange behaviour error writing data to connection - but after some time connection is back.

My guess is that is the firebird sweeper http://www.firebirdsql.org/manual/gfix-housekeeping.html You can disable autosweeper and try to do it manually

Re: [firebird-support] Strange behaviour error writing data to connection - but after some time connection is back.

Hi, Most likely you did not change default configuration of xinted, which has restriction in number of connections/second. Set it to unlimited or some bigger value. Regards, Alexey Kovyazin IBSurgeon Hi guys, I have problems which I can not explain, nor do I know how to solve it. We have

Re: [firebird-support] Strange behaviour error writing data to connection - but after some time connection is back.

Thank you, I have about 800 connections and limit is set up on 3...

[firebird-support] Re: Strange behaviour error writing data to connection - but after some time connection is back.

jimi_compot thanks for the suggestion. Does automatic sweep causes of spawning another fb_inet_server process? Because I have a lot of processes that I am not able to identify. I''ve checked all my databases and could not find those processes in system tables.

[firebird-support] Re: [ib-support] How can I convert TIMESTAMP to DOUBLE PRECISION???

how to extract time from double value for ex.42429.96079

RE: [firebird-support] Re: [ib-support] How can I convert TIMESTAMP to DOUBLE PRECISION???

how to extract time from double value for ex.42429.96079 For what purpose? There are a couple of options, depending on what you want to do with the result. Sean

[firebird-support] connection problems

Hi there, first I'd like to say that I am new to this group and could not find a conversation that fitted my situation and I decided to start a new one. So please forgive me, when this topic has already been discussed over again. I have been using firebird for several years and have

Odp: [firebird-support] connection problems

Hi I think that your app use gds32.dll instead of fbclient.dll. look if it is present on your computer Regards, Karol Bieniaszewski - Reply message - Od: masb...@za-management.com Do: firebird-support@yahoogroups.com Temat: [firebird-support] connection problems Data: wt., kwi 8, 2014

Re: [firebird-support] Large delays ( 10 seconds ) for queries on small databases

answering myself: it is evidently a kernel problem. With the change from 3:11:10-7-default to 3:11:10-7-desktop the problem disappears. Am 10.03.2014 10:24, schrieb Georg Weickelt: Hello, we use a CAD system (CARD / 1), which saves a few settings in a Firebird database. There is a central