Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Displaying Pictures in Image Control
Message
De
26/07/2007 12:20:14
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
01243634
Message ID:
01243812
Vues:
22
Thanks for the info...now I have a followup problem. This worked great using a blob field in FoxPro. But it needs some tweeking to work with SQL Server.

I've created an image field on the form and I'm using SQL views to the SQL Server Table, in the refresh event I have the following code:

THISFORM.pageframe1.contact.imgContact_Picture.PictureVal = ;
contact.contact_picture && Where contact.contact_picture is field in the view.

I get an error that this is not allowed with General Fields. Now I didn't create a General Field, but an Image field in SQL Server. And I used the following syntax to create the view:

CREATE SQL VIEW someview REMOTE ;
CONNECTION someconnection SHARED ;
AS SELECT * from sometable

So it seems as if VFP interprets the Image Field as a general field when it creates the view. BTW, I first tried using just a "text" (Memo) field and it worked fine, except it blew up on some pictures because of the contents of the picture (it probably had inbedded CHR(0) or something, so that's why I decided I needed to change to an image-type field.

Ideas anyone?

Thanks. Bob
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform