Solved

MSSQL 2005 and writing to blobs

Posted on 2006-11-10
2
140 Views
Last Modified: 2012-05-05
Hi,

I have an app I wrote in D2005  that uses an MSSQL 2005 server for the backend. The column I'm trying to save data to as a blob is a varbinary column.

I'm taking an open file in an editor saving it to a memory stream and then attempting to write it to a blob. Everything is fine until I get to here

tblobfield(tb_org_mast.FieldByName('org_dat')).LoadFromStream(ms);

Then I get an error that says the field is not blob.

What's wrong?

Thanks,
Greg
0
Comment
Question by:Mrgregoman
2 Comments
 
LVL 17

Accepted Solution

by:
mokule earned 500 total points
ID: 17921399
Hi,
define image column not varbinary
0
 

Author Comment

by:Mrgregoman
ID: 17929995
OK, that worked. Why does Varbinary not work?
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

The uses clause is one of those things that just tends to grow and grow. Most of the time this is in the main form, as it's from this form that all others are called. If you have a big application (including many forms), the uses clause in the in…
In this tutorial I will show you how to use the Windows Speech API in Delphi. I will only cover basic functions such as text to speech and controlling the speed of the speech. SAPI Installation First you need to install the SAPI type library, th…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question