Hi all, Is there anyone that could give me a detailed explanation on multiplication of different data types. data type of result of this operation is not very...
Hi, ... Define "different"? Rounding errors? ... In these cases, I suggest using fixed-point datatypes, not floating point. This would be: NUMERIC(18, 2) or...
What about having another table, populated through triggers on the reservations table. The new reservation_dates table would, in your example, contain: ID...
... As others have told you, a database is the outer bound for any query. What you could try to do, is to have a fourth database and replicate from the three...
... fixed in ... I use Firebird 1.5.1.4481 ... it. ... the ... Any more info here. It would be great if I could do this. By simply overwriting the file....
... From: "Helen Borrie" <helebor@...> To: <firebird-support@yahoogroups.com> Sent: Wednesday, March 01, 2006 2:40 AM Subject: Re: [firebird-support]...
Rony Cesana
r.cesana@...
Mar 1, 2006 10:53 am
72839
... Hi Rick, I've had only good experiences (none of what you're describing) with ReiserFS. There's too little info in your email to elaborate further on what...
Jan Bakuwel
jan.bakuwel@...
Mar 1, 2006 11:08 am
72840
division operation doesn't returns decimals For instance: select (123/100) from inv returns 1 Any comments are accepted Regards Dennis [Non-text portions of...
... And where's decimals? You divide integer to integer and get integer as the result. What's wrong? -- SY, Dimitry Sibiryakov....
Dimitry Sibiryakov
SD@...
Mar 1, 2006 11:21 am
72843
Hi! We experienced a strange behaviour: calling gbak via cron or commandline our backup of a 35 gigabyte database lasts around 4 hours. During this time we...
Hi, Thank you to all for their advice, I have now solved the boolean problem. Now, if we could just get OpenOffice and Firebird to talk to each other about the...
Robin Davis
ro.davis@...
Mar 1, 2006 12:43 pm
72845
... I can't guess the cause of the performance difference between local backup and service manager doing it for you (which is what the third party tools use). ...
... You can use gbak either as application that does the job directly (i.e. reads data usually over network layer, which can have some slow down effect), or...
Thanx This works select (123/100.0) from inv but generally when I do calculations (in sum()), in precise multiplies with 4 decimals, I get the error ...
... Still, given your recent experiences (as described eventually) it would be worth checking the "Path to Executable" field in the property sheet of server...
... It reads: C:\Programmi\Firebird\bin\fbserver.exe -s What does it mean, by the way? Rony...
Rony Cesana
r.cesana@...
Mar 1, 2006 2:43 pm
72850
I need to develop a WEB Application and I'd like known which rad solution is the best and which connection for Firebid. Actualy I have Delphi 2005.
Thank You ...
... Emotive question :-) ... If all your skills are currently in Delphi, then use Delphi. You could easily develop ISAPI or CGI to make a website. Personally...
... Yah, I know. The field is wide open, and our resources are limited. So I'm hoping that the group knowledge would give us a starting point, rather than us...
Rick Debay
rdebay@...
Mar 1, 2006 5:37 pm
72854
... Carlos Guzman (The FirbirdClient developer) has an example of creating a Stored Procedure in C#. The page is in Spanish and I don't know if this applies to...
Well, I know a RAD tool at http://www.turbophp.com/, is free, have library to connect to Firebird and the code generated is in PHP. Regards, Si Carter...
hi-- i am just beginning a conversion from BDE to FB / IBO. one of my main concerns is the number of fields per record/row in FB. the BDE is limited to 255 and...
... The problem is that - following the dictates of one interpretation of the SQL standard - Firebird does not do any internal rounding in arithmetic...
We have a customer that is running Win 2000 Server patched to Service Pack 4. They have been running our software for a year or so. Our software is using the...
... bit ... concerned. ... Also, is this of interest for me or is this cause IB specific? I know there is a 2GB limit but I don't think I am near it at this...
