Subject Re: [ib-support] Inserting a Blob from within a stored procedure
Author GreatDayDan
Good Morning!

The app uses BDE, but I want to do this from within
the sp compliled into the db.

It will be just text but the field is already
defined as Blob Sub_Type 0 and cannot be changed.

I will be building a string list to put in the blob
field.

Thanks...Dan'l


--- Daniel Rail <daniel@...> wrote:
> At 28/03/2002 01:42 PM, you wrote:
> >Good Morning!
> >
> > I am using FB RC2 (I will be upgrading to V 1.0
> soon) and Win NT
> >SP 6a.
> >
> > I have a table (PP) with a field (Notes)
> defined as Blob Sub_Type
> >0. I also have a sp that inserts records to this
> table. I want to put
> >some text in the blob field. The client program
> (written in D4) uses
> >tables (I know! But that is for a later upgrade)
> simply posts any
> >data, including the blob data.
> >
> > What do I need to do, in the sp, to add data to
> the blob field?
> >Use the API calls? How? Do I need to create the
> string first, then
> >add it to the blob, then use the blob_id as the
> value for the Notes
> >field? Is this done with a cursor?
> >
> > Can you give me or point me to an example
> (preferbly in Delphi)?
>
> What are you using for connectivity? BDE, FIBPlus,
> IBO or anoher
> method? Is it just a text memo field you are
> assigning to?
>
>
> Daniel Rail
> Senior System Engineer
> ACCRA Group Inc. (www.accra.ca)
> ACCRA Med Software Inc. (www.accramed.ca)
>
>


=====
____________________________________
Every day is a Great day, but
some days are GREATER than others!

__________________________________________________
Do You Yahoo!?
Yahoo! Movies - coverage of the 74th Academy Awards´┐Ż
http://movies.yahoo.com/