Documents stored in SQL table

Posted by vradenburg on Stack Overflow See other posts from Stack Overflow or by vradenburg
Published on 2010-05-07T21:00:22Z Indexed on 2010/05/11 11:34 UTC
Read the original article Hit count: 230

Filed under:

msword

|

foxpro

|

sql

|

General

I have a legacy FoxPro application which stores documents in an SQL table in a field with the image datatype. FoxPro accesses the image datatype as a "General" field which can be used to store various files. I have a FoxPro control which interfaces with the General field for modifying/viewing the document that was stored. I need to migrate this control to .NET and make it easy for users to view/modify documents of various types.

Does anyone have any suggestions on some ways to go about this or know of things that I'll need to consider for the migration to .NET? I'm pretty sure that I'll need to migrate the field to either a varbinary(max) or FileStream data type.

© Stack Overflow or respective owner

Related posts about msword

jquery prevent paste to iframe designmode from msword

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi. I've seen some questions on catching paste event. This looks helpful. But I want to prevent paste from happening when the pasted content is not plaintext, but comes from msword or other wysiwyg editor. Anybody got any experience on that? I suppose I should catch the event and look for some specific… >>> More
Trouble accessing MSWord ActiveDocument

as seen on Stack Overflow - Search for 'Stack Overflow'
When I try to programmatically access a word object model, I get an error no document is active. This appears to be because I am loading the document as not visible using Word automation, and I have to keep it invisible. How would I code the open macro so that it does nothing in this case? "If… >>> More
MSWord automation:Get file contents after it was saved

as seen on Stack Overflow - Search for 'Stack Overflow'
I have an application that uses MSWord automation to edit some documents, after they save and close word I need to grab the modified file and put it back on the repository, there is only one scenario where I can't get it to work and that is when the user makes changes to the file, selects to close… >>> More
How to convert Msword file into a text file and storing it in Mysql - php joomla

as seen on Stack Overflow - Search for 'Stack Overflow'
Hey i want to convert MsWord doc file into text file - any code sample. And then i want to store it to in database MySql - any code. And also how to retrieve it in a same format tht was in Msword file using php joomla >>> More
Can I use a MIME type declaration to get an HTML file to open in MS Word?

as seen on Stack Overflow - Search for 'Stack Overflow'
Bill James wrote: I was able to render an HTML page with the MIME type set to "application/msword", which caused the browser to spawn Word which imported the html just fine, allowing edits and saving just as if I'd output a real Word doc. That sounds great to me, but I haven't been able to get… >>> More

Related posts about foxpro

foxpro to pdf and pdf to foxpro

as seen on Stack Overflow - Search for 'Stack Overflow'
how will i convert pdf database converted from foxpro back to foxpro >>> More
The dynamic Type in C# Simplifies COM Member Access from Visual FoxPro

as seen on West-Wind - Search for 'West-Wind'
I’ve written quite a bit about Visual FoxPro interoperating with .NET in the past both for ASP.NET interacting with Visual FoxPro COM objects as well as Visual FoxPro calling into .NET code via COM Interop. COM Interop with Visual FoxPro has a number of problems but one of them at least got a lot… >>> More
Does VBA have an equivalent of "Text To" from Visual FoxPro

as seen on Stack Overflow - Search for 'Stack Overflow'
Visual FoxPro supports syntax such as the following: Text To VariableName TEXTMERGE noshow select * from..... EndText This assigns the value of all text between "Text To" and "EndText" to the variable. It eliminates the need for multi line statements separateed by "+ ;" Does VBA have something… >>> More
How easy is it to convert an application from Visual Foxpro 6 to Visual Foxpro 9?

as seen on Stack Overflow - Search for 'Stack Overflow'
Are there any problems converting a Visual Foxpro 6 application to Visual Foxpro 9; or is this straight forward? Any gotchas that I should watch out for during the process? >>> More
Speaker at developer conferences and user group meetings

as seen on Get blogged by JoKi - Search for 'Get blogged by JoKi'
Catching up on a couple of sessions I did in the past. This article gives an overview of some of my activities. Mainly at the annual German Visual FoxPro Developer Conference also known as SQL-Server & ASP.NET Conference in Frankfurt. The below listed entries are excerpts from the original Conference… >>> More