Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Stefan Kleindienst
Starting Member
2 Posts |
 Posted - 2001-11-16 : 14:31:27
|
| Hello to all visitors of this forum,I have a certain problem and it seems to be impossible to find valid informations to solve my trouble. Using SQL Server 7.0 in conjunction with a MFC-based client app I intend to store a binary data file (that is a CrystalReport rpt file) in a column of data type IMAGE. The goal is to deploy the latest version of a rpt file by storing it to the database. The client app compares file information of the local copy with matching information on the database. When the report stored to the database is a newer version than the local copy, the client should fetch the new report from the database and save it as his new local copy. Now I have some troubles:1. How do I get the existing file (rpt) into my IMAGE column? Is it possible by using TSQL or must I create a smart tool app?2. What is the valid class for the matching data memeber in the recordset of the client app. MFC´s wizard uses CLongBinary, current documentation declares this class as obsolete (use CByteArray instead). Does anyone of have a useful hint? Thank´s a lot. |
|
|
|
|
|
IMAGE data