Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Printing Image
Message
De
08/09/2012 03:10:23
Muthu Vel
Sty Company
Inde
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Titre:
Printing Image
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01552604
Message ID:
01552604
Vues:
100
I have call_letter.dbf having fields with regno, name, category, mark, rank, address. The address field is memo.I have student address as Image format i.e JPEG having same regno. using below code i set image path to address field.

lcPictureFolder = ADDBS("D:\Muthu\ADDRESS")
USE test AGAIN IN 0 ORDER jacno

UPDATE call_letter SET address=addbs(m.lcPictureFolder) + LTRIM(str(address.regno)) + ".jpg"

i have placed Picture/OLE control on my report.frx for printing the image. I set control source = call_letter.address. when i run the report all the image in the path would print. In some situation i want to print selected images. so create a form and placed two text boxes and one command button . let assume i want to print the image regno from 20001 to 20025 so i written the code on click event of command button shows below

USE call_letter AGAIN IN 0

LOCAL lnfrom
LOCAL lnto
lnfrom = VAL(thisform.text1.Value)
lnto = VAL(thisform.text2.Value)

SELECT * FROM call_letter WHERE jacno between lnfrom AND lnto
report FORM "report.frx" TO PRINTER NOCONSOLE

But again it will print all the image in the path.

How to correct my code and How to print selected image?
Répondre
Fil
Voir

Click here to load this message in the networking platform