At 01:04 AM 26/05/2003 +0200, you wrote:

>Hi
>i need a way to indexing words of files and store it in database
>i use firebird 1.5 rc1
>i know in firebird not have this, but i am need towork udf to indexing blob
>with small storage for achiving application

You can add an extra column for each keyword you want to store (ugly) or
you can add a new 1:many relation, with a foreign key to your table, which
stores your keywords (the right way to do it in a RDBMS). Your
applications (or a console application) would have to provide the means for
harvesting and utilising the keywords.

Alternatively, for automating both the definition of columns in the
database that you want to be keyword-searchable and for the harvesting of
the keywords: if you have access to Delphi, Kylix or C++Builder, IB
Objects has full-text support components which work on any char, varchar
and blob sub_type 1 columns which you define in your set-up. This can be
set up as a daemon or service application to work independently of any
client applications. The FTS module comes with a demo setup program (for
Windows) which you can actually use as a console tool to install FTS, even
if you are not otherwise using Delphi/Kylix/C++B for your client
development. It doesn't use UDFs at all - the whole process occurs inside
the database, using triggers.

For more info see http://www.ibobjects.com/ibofts.html - follow the link
through to the on-line help file which gives a walk-through on use of the
demo program.

You might also like to post your question to the firebird-tools list, as
developers are coming up with new tools constantly. Subscribe at
http://www.yahoogroups.com/community/firebird-tools

heLen