General information
Category:
Third party products
Update: Using a variation of the method in Vlad's FAQ I can get the image stored in the SQL table. Still can't get it to display on my form via the OLE control.
>I need to be able to retrieve and update small BMP images stored in SQL IMAGE fields using DataClas/VFP. It appears that any fields of the IMAGE type are ignored - if I reference the IMAGE field in an OLEBoundControl (using ThisForm.oMasterObject.oObjectStore.myimagefield), I get an error that this property is not found and the control is unbound. When I execute the save method, I get an erros that the stored procedure is expecting a parameter that hasn't been passed - this happens to be the image field. So it would appear that the storage and retrieval mechanism completely ignores the IMAGE types. Since Crystal Reports also cannot display images if connected via ADO (but does fine for ODBC connections), is this a limitation of ADO and not DataClas/VFP? Is there any solution? Storing just the picture file name is out of the question as there is no way to display it in Crystal Reports. These are tiny files (< 1K) so data storage is not an issue here.
>
> Randy
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only