At 06:29 PM 25/03/2006, you wrote:

>Thanks Helen,
>
>Can you suggest any other way I might accomplish the goal of storing
>multiple (but unknown numbers) of files in a firebird database with IBO?
>
>I would guess that this is something people might commonly want to do,
>I want to use it to attach related files to a particular client.

Define a table and store one file per table. As a minimum, a "file
record" would contain a primary key (document_id) and your blob. But
you would want to add other attributes, e.g. a node_id and
parent_node_id if you wanted to do your simulated directory tree
structure; you might want a title, a short summary, creation and
update dates, author, assignment_id, keys to keyword entries,
grouping identities, etc.

You can manipulate the ways the document is passed around, relocated,
etc., using relationships: basically, design a relational structure
that enables you to put your document exactly where you want it, when
you want it.

Helen

>Jason Gagnon
>
> > Storing multiple files per blob doesn't seem feasible to me. The
> > database would have no way to determine when one file ended and the
> > next one began.
> >
> > Helen
> >
>
>
>
>
>
>
>___________________________________________________________________________
>IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
>___________________________________________________________________________
>http://www.ibobjects.com - your IBO community resource for Tech Info papers,
>keyword-searchable FAQ, community code contributions and more !
>Yahoo! Groups Links
>
>
>
>