SQL Object

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.
 
See Also
RetrieveFileFromField, StoreFileInField.
Example
 
Sub Main
 
   SQL.StoreImage ProductImage, 488732, "c:\artikel_488732.jpg", 1
 
End Sub