Easy question: Copy Image to a File

How I can copy an image to a file?

I want to use SP

I use MSDE, textcopy is not installed

I can use bcp, but I don't understand the syntax for image filed

Something like this

bcp "SELECT [ImageFiled] FROM MyDatabase..MYTable WHERE [ID]=1111" queryout c:\test.BMP -c -Sservername -Usa -Ppassword

This statement dont work.
Please I need an example.

Thanks,
Sorry for my Englishhttp://www.databasejournal.com/features/mssql/article.php/1443521 to feature the task.

Easy Problem I Should think, cr11 vb6 image

In a nutshell

I have a report, and a vb6 which calls it, thou the results are not the same, when called from vb6, other then just opening in cr and runing it.. The only thing which is different is that the dynamic location images, does not appear, everything else does ?

In a Sea Sure Shell

Vb does not pass anything to the report, because the report always looks at the same database (mdb) when it runs, infact i just fill the database as i want with vb, and then call the report..

Its just one record in a 6 colum type, all text fields, one date time field..
All of which show fine, apart from one, being a txt field which contains a location of a picture such as C:\Pics\blah.jpg

But this does not show on the report when called, just the other records..

I am using the new Image Location field in cr11, which i've used lots, so i know the reports right and works fine, because like i said, if i preview in cr itself, it works great..

So the problem must be when i call it, in my vb program, i have the following code

======Code=============
Dim oApp As CRAXDRT.Application
Dim oReport As CRAXDRT.Report

Set oApp = New CRAXDRT.Application
Set oReport = oApp.OpenReport("C:\offer.rpt", 1)

crvMyCRViewer.ReportSource = oReport
crvMyCRViewer.ViewReport

frmPrint.Show
======End Code==========

Which shows it on the screen, but with no pictures, i've checked the database, file path is fine

anyways come across this b4 ???

Any help on this would be great

thanks for your timewow paul, your so good looking|||stop that, this is a serious question|||look like no ones know mr paul|||i'll cry if no ones help :-(|||anyone ? i lose my job, if i dont work this out by 2morrow :(|||well thanks for your help everyone, i worked it out myself, and as i'm nice, i'll tell you how incase anyone else has this problem in the furture.. its just taken me 2 days to work this out

but because i had cr10, then 11 and both were installed it seem, i had a ref to cr viewer and active x dll's 10 and not 11, so althougth the report showed, ofcouse the advanced thing which comes with v11, does not work such as the dynamic image location.

So i got my hands on verison 11 of both dll's and it work, ta da

Dynamically change the Image Location

I've hunted all over for the answer to this without success...
I'm trying to display a company logo at the top of the report, but read from
the database whether the logo is left justified, right justified, or
centered. I figured I would just adjust the Left property of the image to
get it left/right/centered, but I can't find any way to modify the Location
of the image other than to set it at design time.
I found one suggestion to stretch the image control and use padding to
"center" the image, the problem however is that I also need to dynamically
locate the company address depending on the location of the logo. <sigh>
As usual when I can't find a solution, I'm getting that ominous
"it's-right-in-your-face" feeling...
Thanks,
JLSTom, I am running into the same issues. I want to dynamically change the
<Top> position of an image depending on a value passed to a Function. I am
not having any luck either. Just wondering if you found a work around?
Thanks, Phill
"Tom Rocco" wrote:
> I've hunted all over for the answer to this without success...
> I'm trying to display a company logo at the top of the report, but read from
> the database whether the logo is left justified, right justified, or
> centered. I figured I would just adjust the Left property of the image to
> get it left/right/centered, but I can't find any way to modify the Location
> of the image other than to set it at design time.
> I found one suggestion to stretch the image control and use padding to
> "center" the image, the problem however is that I also need to dynamically
> locate the company address depending on the location of the logo. <sigh>
> As usual when I can't find a solution, I'm getting that ominous
> "it's-right-in-your-face" feeling...
> Thanks,
> JLS
>
>