Hi,

With Firebird, you can use this:

mytable
(
myblob blob sub_type text
)

insert into mytable ('test blob text');

With InterBase, you have to either use a parameterized statement (see
www.upscene.com - Tips section for an example) or a UDF to do this. Download
the several free UDF libs, there are some that have functions for this.
--
Martijn Tonies
Upscene Productions

InterBase Workbench - The Developer Tool for InterBase
http://www.interbaseworkbench.com

"Experience is what you get when you didn't get what you wanted"

""C Fraser"" <Colin.Fraser@...> schreef in bericht
news:001801c1779f$0dc87170$8f01a8c0@COLINFRASER...

> I know it has been asked before... But I haven't been able to find the
> answer...
>
> Is it possible to insert strings into BLOBs (subtype 1) using SQL???
>
> Any stored procedures or user defined functions (Free UDF?) that can
> help?
>
> I also recall something about Firebird being able to do it in an
> upcoming (or current?) release?
>
> Any info appreciated.
>
> Regards
> Colin
>
>
> ######################################################################
> Attention:
> The information in this email and in any attachments is confidential.
> If you are not the intended recipient then please do not distribute,
> copy or use this information. Please notify us immediately by return
> email and then delete the message from your computer.
> Any views or opinions presented are solely those of the author.
> ######################################################################
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>