General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
I've done this for different applications for over two decades now....and despite the advances that SQL Server has made with newer data types (like the FileType in sql2012), I really prefer a good old fashioned approach of storing the images in shared folders with a table catalog. SSRS (and other report writers, including the VFP report writer) have ways to show images dynamically in a report. If you want to describe your situation with some specifics, I'm sure there are a few people who can offer good suggestions.
I have used that approach as well for images and display the image in an image control. To show the image / document I just use ShellExecute
>Hi!
>
>I have a table that holds data for the company's customers, and I need to store the id card for each one of them. So, I wonder what the best way is to store .jpg or .pdf files and how it can be done with Visual FoxPro 9 connected to the SQL Server Table. And then how to show the .jpg or .pdf files within my Visual FoxPro application.
>
>Thanks in advance.
>
>Luis
Previous
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