Hello, I use Firebird BLOBs to store documents. My transactions could be safely split in two parts, one that stores the document, one that shows it to the...
Order from ibphoenix.com instead to help support firebird ... -- Nick ... Founder & Listowner of the Prolifics User Group Panther, Ingres, UNIX, Interbase,...
That's right Alexandre. You could of course make (count)tables for each number of criteria and create a combined primary key. TABLE ( X, Y1, Y2, Y2, . Yn, ...
... Additionally to all that others have already wrote, if you still want to extract the data and copy into new database, you can use the FBCopy tool, which is...
I was thinking. I have a table of 150,000 companies. I want to look up a company by combining all (relevant) fields of the company, parse it and put the words...
my firebird server hangs, I don't know thre reason because nothing is reported in logs, I can give you ps output and tell that I am using rfunc library and...
Maris Paupe
codeine@...
Mar 1, 2005 11:38 am
56504
That might work, as might the equivalent any more normal way to do it: select max(id) from table But it may not be safe to assume that every ID is used. In...
Helen, The server was not started... If I put to my hosts file this: 127.0.0.1 mcfly localhost mcfly This error stops. And then: If I open a query tool that...
... I'm not shure. As I said - UDFs work on Linux - with the SQL statements. ... Both (client and server) are installed on the same machine (on the mac). I...
... If this is ps -afx output, then no clients are connected. R means it's using CPU. What does "I" signify - is this something peculiarly Debian? What does a...
Alan and Urs, Thanks to your helpful comments I now have a backup running nicely with an embedded server - and understand better what's going on :-). In the...
Hibernate has a configuration that specifies the dialect of SQL to use. Their documentation (version 2.x) states that with Interbase/Firebird, use "NONE", even...
... involved ... I want to find the most efficient way to find duplicate linkages. In the stored procedure tha populates the table, it already looks for ...
Hi, i have a 100gb database consisting of one table to store a key value and binary document in a blob field. lately i have some cases when insert in to the...
I'll reply to this one as well, since I spawned both threads... Per your earlier reply, I was not restarting the Firebird service each time I made changes to...
Thanks for the tips. I'm embarrassed to say that my problem was that I was not restarting the Firebird service after adding "UdfAccess = Restrict UDF" to...
... OK, first, get rid of that compound index because it doesn't do anything useful. Then index both SD_INVOICE and SD_GTID (2 indexes, not one). Now,...
Hi, is there a reliable way to subtract e. g. 100 years from a date value? My problem is that I would like to subtract 100 years from a given set of date...
I finally upgraded to 1.5 Classic on Fedora (sorry but product release is killing me) and met many new surprises. I got things to work mostly, but ran against...
... At least approximately: select datefield - (100 * 365.25) from table ... (Problem are the leap years) ... Magnus...
Magnus Titho
magnus.titho@...
Mar 1, 2005 3:49 pm
56519
... Indeed. And they depend on the original year given. Perhaps it would be better to write an UDF in which you decode the date, subtract 100 years and encode ...
I'm new to Firebird and a little lost. I am using v1.5.2 embedded database. For the most part, I have been able to create my database with tables, columns,...
I've been trying FirebirdDialect with 3.0, and have gotten enough help here to realize that Hibernate is trying to call the UDF "lower" and that I need to...
Hi, ... The above should work just fine on a Dialect 3 database. ... With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird,...
Hi, you could try select cast (extract(day from datefield) || '.' || extract(month from datefield) || '.' || (extract(year from datefield)-100) as date) from ...
... Yeah, but if the date is a 29.02., you would also have to check if the calculated year is also a leap year (e.g. 29.02.2000 minus 100 years -> 28.02.1900...
Magnus Titho
magnus.titho@...
Mar 1, 2005 4:20 pm
56525
Hey!!! I write an aplication in VC.net, and need detect events with isc_wait_for_event() function. * I can attach database. * can start transaction. * can...
