Re: [firebird-support] FDB networking

2012-03-16 Thread Helen Borrie
At 10:22 AM 16/03/2012, Marc Gilels wrote: I finaly got a hold of my IT/programmer and he claims that this new software has FB imbedded and that every version is the same version for server and client..he is going to get back to me with help. It will be interesting to see since he

RE: [firebird-support] UDF Question(s)

2012-03-16 Thread Kevin Stanton
One last thing: I'm using FB 1.56. Thank you, Kevin From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Kevin Stanton Sent: Friday, March 16, 2012 6:53 AM To: Firebird Support Subject: [firebird-support] UDF Question(s) Greetings, I'm

RE: [firebird-support] UDF Question(s)

2012-03-16 Thread Jerry Sands
Extract(Day from MyDate) Extract(Month from MyDate) Extract(Year from MyDate) DateDiff(Day from FirstDate to SecondDate) (you can substitute Month, Week, Hour, Minute, Second, and MilleSecond as well. These are all in FB V2.1 I'm trying to eliminate the need for the FreeUDFLib so I

RE: [firebird-support] UDF Question(s)

2012-03-16 Thread Jerry Sands
Oh, FB 1.56 - well good luck then - Jerry From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Kevin Stanton Sent: Friday, March 16, 2012 9:00 AM To: firebird-support@yahoogroups.com Subject: RE: [firebird-support] UDF Question(s) One last

RE: [firebird-support] UDF Question(s)

2012-03-16 Thread Kevin Stanton
Thanks for the info Jerry! From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Jerry Sands Sent: Friday, March 16, 2012 7:02 AM To: firebird-support@yahoogroups.com Subject: RE: [firebird-support] UDF Question(s) Oh, FB 1.56 - well good luck

RE: [firebird-support] UDF Question(s)

2012-03-16 Thread Kevin Stanton
Hi Set – should those functions be in FB 1.56? I will go test. Thanks, Kevin From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Svein Erling Tysvær Sent: Friday, March 16, 2012 7:05 AM To: 'firebird-support@yahoogroups.com' Subject: RE:

RE: [firebird-support] UDF Question(s)

2012-03-16 Thread Kevin Stanton
Perfect! – those work in 1.56. J I have tried (quickly) the date2 – date1 and it does seem to return an integer. More testing to do but all looks good. Thanks for the help! Kevin From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of

Re: [firebird-support] UDF Question(s)

2012-03-16 Thread Iwan Cahyadi Sugeng
Try This : On Fri, Mar 16, 2012 at 8:52 PM, Kevin Stanton kevin.stan...@rdb-solutions.com wrote: ** Greetings, I'm trying to eliminate the need for the FreeUDFLib so I can have the option of running Firebird 32-bit or 64-bit. I believe I'm down to 4 UDFs - are there any replacement

Re: [firebird-support] FDB networking

2012-03-16 Thread Ann Harrison
On Fri, Mar 16, 2012 at 5:02 AM, Kjell Rilbe kjell.ri...@datadia.se wrote: 1. Modify the application to be able to connect to a real server, i.e. don't use embedded Firebird. This would also require a complete overhaul of the sourcecode to make sure it handle concurrency and update conflicts

RE: [firebird-support] UDF Question(s) - a couple more

2012-03-16 Thread Kevin Stanton
Greetings, I believe I'm down to just 3 UDFs and was wondering if there are any replacements for: F_ADDMONTH F_ADDYEAR F_AGEINMONTHS Also, is there a place where I can get a list of all functions for FB 1.56 (and beyond)? I've taken a quick look but it's not jumping out at me. Thanks! Kevin

[firebird-support] Re: Firebird 2.5 very slow on Centos 6.2

2012-03-16 Thread Dmitry Yemanov
16.03.2012 16:45, jsbriantes wrote: But, forced writes off is dangerous, isn't it?. It depends on how much you trust your hardware. And it's still not a 100% guarantee anyway. Speed and reliability are orthogonal terms, usually you have to choose only one and live with the restrictions.