Adding OLE on stock items in quote layout

Hi,

Has anyone been able to work out how to show the product images from Stock Processing > OLE into a layout so that the photo is shown alongside the product code?

I think you use the ZOLE table but I don't know to get it to pick the product codes corresponding image for every line.

Thanks in advance,

Bhav

Find more posts tagged with

Pegasus - Partner General Discussions

Comments

alan-bourke

Create a white or transparent BMP file called 'empty.bmp' and put it in the reports folder.

Add your OLE-bound control to the quote layout.

For Control Source Type, specify 'Expression or variable name'

For the Control Source use:

iif(seek(padr("CNAME",10)+it_stock,"zole","zole2") and File(zole.imagefile),zole.imagefile,goapplication.paths.report+"empty.bmp")

Always make sure when attaching the OLE images in the first place that you pick them up off a network location so that a UNC path goes into ZOLE.DBF for them. Otherwise some client PCs may not be able to see them.

unknown

Hi Alan,

Thanks for getting back to me. Not sure I follow where to add the expression above in, once I add an OLE object/control I get the below screen. Where do I add the details in there? Also will this expression pick up whatever photo is linked to a stock item? Thanks again for your help with this.

alan-bourke

That's the old pre-Visual FoxPro 9 report designer. Try it in the 'Field' section. Yes if the imagefile field is populated and the file can be located it will display it, otherwise it will display empty.bmp

unknown

That's just the layout you get when previewing the standard quote layout when logged in as ADMIN.

Would I need to user full VFP9 to do this?

It doesn't work if I enter it in the 'Field' section, the report crashes.

unknown

I've tried typing the full Control Source into the 'field' field but it then asks for the location of the bmp and after browsing for this the 'field' box then empties.
Anyone have a solution without having to install full VFP?

Copyright © 2025 Infor. All rights reserved.