Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Displaying images in Foxpro from SQL Server
Message
General information
Forum:
Visual FoxPro
Category:
Pictures and Image processing
Miscellaneous
Thread ID:
00657752
Message ID:
00657789
Views:
26
Thanks for answering Tom. I have used the following commands in an attempt to store a .bmp:

cSQL="INSERT INTO Picture (Picture) VALUES ('C:\HOLD\MRFOX.BMP')"
nSuccess=SQLEXEC(oApp.oConn,cSQL)

DO you actually store a character value to a SQL text type field or do you attempt to store the binary representation of the image itself? If so do you have any examples of SQLPass Through code that will allow me to retreive and display the image??

>>Does anybody know of a way to use SQLExec() commmands to store and retrieve images to and from a SQL Server 2000 Image type field?? Thanks!
>
>The way I do it is to reference the path and file name + extention as a character field.
>
>Tom
Previous
Reply
Map
View

Click here to load this message in the networking platform