Subject | Re: [IBO] BLOB Copy |
---|---|
Author | ra8009 |
Post date | 2007-06-25T17:57:30Z |
--- In IBObjects@yahoogroups.com, "Alan McDonald" <alan@...> wrote:
in code?
>Is there also a way to do this using IB Objects and field references
> > How do I copy the contents of a BLOB field in one table to a BLOB
> > field in another table?
> >
>
> simple
> UPDATE TABLE2 SET BLOB1=(SELECT BLOB1 FROM TABLE1 WHERE TABLE1.ID=N)
> WHERE TABLE2.ID=Y;
>
> Alan
>
in code?