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