> > No, cause I know how it will work -- I'm just trying to set things
> > straight for people who might have thought that it would work locally
> > from a script.
>
> My SQL Workbench/J (similar tool as your Database Workbench but Java
> based) can do that completely on the client side with a special SQL
> syntax very similar to the UDF solution.
> But as the code is executed on the client side, the application will
> take care of "uploading" the BLOB to the server (and directly into the
> column).
>
> INSERT INTO theTable (id, blob_col)
> VALUES
> (42,{$blobfile=c:/data/image.bmp});

Hmm, I like that syntax ... Perhaps I should do the same :-)

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

> This works for any database where the JDBC driver implements the
> necessary functions, including Firebird. This can also be run in batch
> mode.
>
> The same syntax can also be used to "upload" files into CLOB columns
> Although I'm not sure which datatype that would be for Firebird. Does
> Firebird have a character datatype that can hold more than 32K?
>
> Anyone interested, can download the application at:
> http://www.sql-workbench.net
>
> Thomas
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
>
>