Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to insert image into mysql table with vfp
Message
From
24/03/2010 22:06:14
Hee Lim Wang
Fantasy Software Enterprise
Malaysia
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01455978
Message ID:
01457088
Views:
42
strtofile(tmp.bImage, 'c:\myPicture2.jpg')
c:\myPicture2.jpg is the same as myPicture.jpg and can be added into Image1 control manually
but cannot auto added with program coding......

>CURSORSETPROP("MapBinary", .T., 0)
>SQLExec(lnHandle,"select bImage from TableImage","tmp")
>Thisform.Image1.Picture=strtofile(tmp.bImage, 'c:\myPicture2.jpg')
>thisform.Refresh
>
Program error : Data type is invalid for this property


if I use pictureval
>Thisform.Image1.Picture=strtofile(tmp.bImage, 'c:\myPicture2.jpg')

Error with Image1 : PictureVal : property value is invalid.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform