I have a table that holds pictures as datastreams into a Blob field.  Initially I loaded up 10 or 15 - 2MB photos...then I deleted them and converted
them to JPG files reducing their size dramatically....but the BLB file did not change in size...except to grow bigger even though the photos were
reduced.....

Why? and how can I force the BLB file to reset itself?

Pete

Okay Two things. First I realize I put this thread in the wrong path..Second I found my own answer...Optimize the file...but in doing so it created a
COPY of the original file (extension .bbk) and then I presume re-created the .blb)...so when finished I had to delete the .bbk and all was okay.

The question now is can this be done via code using the ODBC driver?

Pete,

<< Okay Two things. First I realize I put this thread in the wrong
path..Second I found my own answer...Optimize the file...but in doing so it
created a COPY of the original file (extension .bbk) and then I presume
re-created the .blb)...so when finished I had to delete the .bbk and all was
okay.

The question now is can this be done via code using the ODBC driver? >>

Use the OPTIMIZE TABLE SQL statement:

http://www.elevatesoft.com/dbisam4d5_optimize_table_statement.htm

after the deletions.  Use the NOBACKUP clause to prevent the DBK, IBK, and
BBK files from being created.

--
Tim Young
Elevate Software
www.elevatesoft.com