Hi,

At Friday, April 03, 2009, 12:40 PM, middasgoldtouch wrote:

> I do have one more question that I believe goes in this forum. As
> I understand how BLOBs work, the data goes into a different table
> and there is an address pointing to that table in the record. Would
> this mean it is possible to assign the same BLOB value to multiple
> records without adding the BLOB data every time? If so, how is this done? Thanks in advance.

If the BLOB is small enough to be on the same data page as the row's
data, it will be stored with the row's data. If the BLOB is too big,
it will be stored in other data page(s), depending on the size. And
yes, the data in the BLOB field, within the row, is a pointer to the
actual BLOB. But, you can't assign the same BLOB to multiple rows or
even across tables. If you wish to reference the same BLOB across
multiple rows and/or data tables, you will have to create a table that
will contain the BLOBs and make the links between those tables
yourself.

And, you might want to consider purchasing "The Firebird Book",
written by Helen Borrie.

--
Best regards,
Daniel Rail
Senior Software Developer
ACCRA Solutions Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)