Re: Blob field
- From: "Alan" <alanpltseNOSPAM@xxxxxxxxxxxx>
- Date: Fri, 2 Jun 2006 15:08:04 +1000
Hi,
What data type should I use in SQL Server 2000 to define BLOB ?
Image ?
Or varBinary ?
"Alan" <alanpltseNOSPAM@xxxxxxxxxxxx> wrote in message
news:447f7a76@xxxxxxxxxxxxxxxxxxxxxxxxx
ThanksTBlobField(ADODataSet.FieldByName('DocField')).LoadFromFile('c:\docfile.doc'
"Steve Zimmelman" <skz@xxxxxxxxxxxxxxxxxx> wrote in message
news:447f078d$1@xxxxxxxxxxxxxxxxxxxxxxxxx
Hi Alan,
You can use something like this:
)TBlobField(ADODataSet.FieldByName('DocField')).SaveToFile('c:\MyDoc.Doc')
or
AStream := TMemoryStream.Create ;
AStream.LoadFromFile('MyDoc.doc')
AStream.Position := 0 ;
TBlobField(ADODataSet.FieldByName('DocField')).LoadFromStream(AStream)
AStream.Free
// save the doc to a file
data
// save to a stream
TBlobField(ADODataSet.FieldByName('DocField')).SaveToStream(AStream);
-Steve-
"Alan" <alanpltseNOSPAM@xxxxxxxxxxxx> wrote in message
news:447e98be@xxxxxxxxxxxxxxxxxxxxxxxxx
What would be the code in like:
ADODataSet.FieldByName('DocField').AsBlob := ....
What would be on the right side ?
"Mike Shkolnik" <mshkolnik2002@xxxxxxx> wrote in message
news:447e80c3@xxxxxxxxxxxxxxxxxxxxxxxxx
You need create the field with IMAGE type
--
With best regards, Mike Shkolnik
E-mail: mshkolnik@xxxxxxxxxxxxx
WEB: http://www.scalabium.com
"Alan" <alanpltseNOSPAM@xxxxxxxxxxxx> wrote in message
news:447e8003$1@xxxxxxxxxxxxxxxxxxxxxxxxx
How do I create a blob field in a SQL Server 2000 table and store
into
it? Like store word document into this column ?
.
- Follow-Ups:
- Re: Blob field
- From: Steve Zimmelman
- Re: Blob field
- From: Dennis Passmore
- Re: Blob field
- References:
- Blob field
- From: Alan
- Re: Blob field
- From: Mike Shkolnik
- Re: Blob field
- From: Alan
- Re: Blob field
- From: Steve Zimmelman
- Re: Blob field
- From: Alan
- Blob field
- Prev by Date: How to swich Database with MSSQL
- Next by Date: Re: TADOQuery exception
- Previous by thread: Re: Blob field
- Next by thread: Re: Blob field
- Index(es):
Relevant Pages
|