Okay,

Found out the answer with a bit of experimentation...

Easy when you know how... Even though F_StrBlob is declared with two
params(param one a varchar and param2 a blob) ... You only use it with
one... I was a bit confused, especially since IB Expert showed both of
the parameters in the hint window (as it should, looking at the udf
declaration)...

Eg.
Insert into aTable (anId, aBlobField) values (1, F_StrBlob('Hello, this
is how you do it'))

Not to sure why... But now I know how it works... And it is oh so
simple!

Colin



-----Original Message-----
From: C Fraser [mailto:Colin.Fraser@...]
Sent: Friday, 30 November 2001 10:40 a.m.
To: ib-support@yahoogroups.com
Subject: RE: [ib-support] Inserting into BLOBs


Ok...

Probably a really simple question... But I can't get it to work...

Using the FreeUDF I do something like this (in a stored procedure)...

a_Blob = F_Strblob(a_VarChar, a_Blob);

Not to sure on how it should look... I haven't been able to find any
examples of how it should work... The error that it comes up with when
compiling is 'Invalid data type, length, or value. function F_STRBLOB
could not be matched.'

Any help appreciated (also, where would I get a later version of the
FreeUDF or the fbudf that was mentioned?)

Regards
Colin



-----Original Message-----
From: news@... [mailto:news@...] On Behalf Of
Claudio Valderrama C.
Sent: Thursday, 29 November 2001 12:03 a.m.
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] Inserting into BLOBs


""C Fraser"" <Colin.Fraser@...> wrote in message
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???

insert into table2(blobfield) values('string literal');

> Any stored procedures or user defined functions (Free UDF?) that can
> help?

Not necessary with FB. The feature has been available for a couple of
public betas, before the RC's. Anyway, freeudflib or fbudf will do the
trick for IB or if you have problems with the built-in feature.

C.
--
Claudio Valderrama C. - http://www.cvalde.com -
http://www.firebirdSql.org Independent developer Owner of the InterbaseR
WebRing


######################################################################
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/



######################################################################
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.
######################################################################