Append Query - images to images

[crystalreporting]

I have a table that has an 'image' type field (BLOB) and I want to append the records to another table that also has an 'image' type field. Both fields are defined identically. My query runs successfully, and the new records look to have image type values in the 'image' field, but the fields do not show up as images when accessed via other tools (Crystal Reports etc.). They work OK in the table I'm appending from, as do existing records in the table I'm appending to. It's only the newly added records that don't work.

Is there something I need to as part of a SQL select/insert statement to specifically handle 'image' type fields?

Peter Shirley
Macola Consultant, PA and surrounding states.

http://www.srhconsulting.com

 

[philhege]

T-SQL has the WRITETEXT and related commands to handle binary data. Be careful, however, as these commands are soon to be deprecated.

What we did was write a C# CLR stored procedure (SQL 2005) that handles the data stream.

Phil H.
Some Bank
-----------
Time's fun when you're having flies.