• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 149
  • Last Modified:

MSSQL 2005 and writing to blobs

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
Mrgregoman
Asked:
Mrgregoman
1 Solution
 
mokuleCommented:
Hi,
define image column not varbinary
0
 
MrgregomanAuthor Commented:
OK, that worked. Why does Varbinary not work?
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now