Jack,

> Oh, well, that is a show-stopper!. I simply assumed that the database knew
> that it should retrieve the binary content from that path and file name.

Why?? The TIB_ component works on the client side - how do you expect
a database engine on a server to get hold of a file on the client or
whereever? :)

> Could you let me have the correct SQL for the insert?

Create a prepared INSERT statement:

insert into ... values (id, :blobvalue)

Call Prepare

ParamByName('blobvalue').LoadFromFile(filename)


With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase & Firebird
Firebird Workbench - the developer tool for Firebird
Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."