> I have created a cursor/table with a decode of the 4char 'header' of the image files stored in a general field of the master table.
>
> LEFT(Image,4) As ImageType, ;
>
> As an example ÿØÿà is stored when the image file is a jpg.
>
> I want to scan through the new table and replace the ÿØÿà with jpg where it occurs and 'jpg' is stored in myfile.
>
> My code
>
> replace mycsv.ImageType WITH myfile
>
> has no effect.
>
> Any ideas anyone?
>
> -Bryan


Replace mycsv.imagetype with myfile in "mytable"

...or...

Replace All mycsv.imagetype with myfile in "mytable"

...or...

Replace mycsv.imagetype with myfile for atc("ÿØÿà", mycsv.imagetype) > 0 in "mytable"


Given that you are showing "Left(image,4) as ImageType" is it possible that mycsv is a cursor you created? If so, ensure that you added READWRITE at the end of your query otherwise the cursor will be readonly.

Craig Boyd
www.sweetpotatosoftware.com