HI, You can use the following procedure SET TERM ## ; CREATE OR ALTER PROCEDURE SPLITTEXT ( ipTEXT VARCHAR(32000), ipSPLITCHARS VARCHAR(20), ipIGNORECHARS...
Hi ! I have one table withe some fields like this ...sum_1,sum2...sum_12 for every month. Inside of a trigger (before trigger) I need to get some of these for...
Hi all, I wanna 'listen' about your experience about applications security schema using Firebird. We support a medium-sized application that has based it's...
Hi Im trying to install version 1.5 on a centos5 linux but get an error related to a missing libstdc++.so.5 - since centos is installed with libstdc++.so.6 I...
Jan Agermose
ja@...
Mar 1, 2008 9:14 pm
92706
... Hi Jan, Here are the solving steps for this issue: http://www.centos.org/modules/newbb/viewtopic.php?topic_id=12316 Regards, Doru...
Hi Peter, ... No 'tricks'. Applying stored procedures in order to compensate the lack of built-in functions isn't objectionable at all. That's what they are...
Christian Danner
christian@...
Mar 2, 2008 12:04 am
92708
Hi Im trying to get firebird running in a apache, php setup on centos. I have the server running now, even with firebird, but it seams I now it seams I have to...
Jan Agermose
ja@...
Mar 2, 2008 12:22 am
92709
... Could you please use the firebird-php list for this question? Same goes for responders, please. ^ heLen...
... Hi Ivo, As you correctly figured, to mantain real security in a database means to grant proper individual rights to each table, stored procedure or ...
Svein, Thank you for your quick reply (and sorry for my late one). Yes, the following works: select count(*) , cast(o.aDT as date) , p.category from orders o,...
Hi all, i use firebird or interbase from version 4. All that time there was small or bigger issues with it, but nothing so serious to blame it. Till now of...
... This smells like a garbage collection (and transaction management) problem. ... This smells like an exacerbated garbage collection problem. ... Have you...
Hi, I have this problem: I have compiled dll with the same name and the same functions similar to dll what I already have, but when I put this on server, then...
Hi Peter! Your select below isn't quite the same as using a LEFT JOIN. It is identical if every order contains a proc_id that is in procs, but it is different...
Hello! I`m kinda confused about how Firebird rounds numeric datatypes. Here`s an example: SELECT CAST(3.6648 AS NUMERIC(9, 2)) FROM rdb$database Results in:...
Martins Lazdans
marrtins@...
Mar 3, 2008 9:01 am
92719
Hi, ... http://en.wikipedia.org/wiki/Rounding Check for "round-to-even" or "bankers' Rounding". Martijn Tonies Database Workbench - tool for InterBase,...
Why would you want to round to 3.67? The bankers rounding that Martijn talks about, rounds to the even number in case of something exactly in between two...
... No, it would only be rounded to 3.67 if the number following the second decimal place was greater than 4. For instance, 3.6658 would give you 3.67. In the...
Thanx for your replies, it seems to me much clearer now :)...
Martins Lazdans
marrtins@...
Mar 3, 2008 9:31 am
92723
That's the point - I have not changed any declarations nor on server nor in the code of dll. I simply recompiled dll. But anyway - here is the example of one...
... 1. How is UDFAccess configured in firebird.conf? 2. Is your library located in the same place as the configuration says it should be? 3. Has the server...
I checked point 3 - but there was not any improvement. I have commented this config variable and I am using the default space for udf libraries - i.e. /UDF...
