Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to display a BLOB field with image control?
Message
De
14/06/2005 06:07:52
 
 
À
14/06/2005 05:54:20
Information générale
Forum:
Visual FoxPro
Catégorie:
Classes - VCX
Versions des environnements
Visual FoxPro:
VFP 9
Divers
Thread ID:
01023015
Message ID:
01023025
Vues:
11
Hi Fabio,

Thank you for taking the trouble.

Now I get an 'Operation is invalid for a General field' error.

In VFP help on Image.PictureVal it says:
You cannot use a general type field for eExpression because general fields store additional unrelated binary data. 
But in order to update the field to SqlServer it has to be of type general.

The LoadPicture() function does not seem to be of any use either.

In short: what to I do?


>>Scenario:
>>
>>1) Sql Server backend
>>Field Logo of type Image
>>
>>
>>Update dbo.Businesses set Logo = 'H:\Develop\Graphics\budget_logo.gif' Where BusinessId = 2
>>
>>(1 row(s) affected)
>>
>>
>>
>>
>>2) VFP remote view
>>Field Logo of type BLOB
>>
>>--Form Refresh
>>
>* PictureVal  is a value, no a cExpression
>This.Logo.PictureVal = MyView.Logo
>>
>>
>>Nothing much happens, so obviously it's a snafu.
>>
>>TIA
Peter Pirker


Whosoever shall not fall by the sword or by famine, shall fall by pestilence, so why bother shaving?

(Woody Allen)
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform