StoreImage

Syntax

SQL.StoreImage ImageMode, NumberOrCode, ImageFile[, VolgNr]

Description

Adds an image to an item, customer or supplier. An existing image can also be replaced.

Parameter	Description
ImageMode	The type of image to save: CustomerContactImage for Customer Contacts, CustomerImage for Customers; ProductGroupImage for article groups, ProductImage for Article Management; RayonImage for Rayons, RayonManagerImage for rayon managers, ServiceProductImage for service items, ServiceTaskImage for service tasks, SupplierContactImage for supplier contacts, SupplierImage for Suppliers;
NumberOrCode	The item number, customer or supplier code for which the image is to be saved. For Suppliers and Customers, the current administration number is automatically used.
ImageFile	The full path and file name of the image to be saved. Must be a valid .jpg, .png or .bmp.
VolgNr	Optional. If omitted, a new image is automatically added to the sequence. The sequence begins with 1. To replace an existing image, enter the sequence number of the image here.

Example

Sub Main()
 
    SQL.StoreImage ProductImage, 488732, "c:\artikel_488732.jpg", 1
 
End Sub