ADO and Blob fields

From: Bolla Sándor <bolla@xxxxxxxxx>
Date: Tue, 26 Apr 2005 14:47:11 +0200

Hi there,

I migrate from FoxPro to MSSQL and in some cases I had copy 'memo' like field to 'text' type fields. I have no problem reading them from the FoxPro database, but I always fail to copy the data into ADO with CreateBLobStream method, but no data has been copied. What make I wrong, in both connection (FoxPor, MSSQL) I use the ADO? As I am not familiar with creating streams I don't no exactly how to use it, i give you an example what I tried to do but I failed, not known the 'mode'-s property of the CreateBlobStream method:

Fox example:
	text_ := adoFox.FieldByName('text').asString;
	adoMSSQL.CreateBlobStream('text', ???);
	.
	.
	.

thx
Alex
.

Follow-Ups:
- Re: ADO and Blob fields
  - From: Brian Bushay TeamB

Prev by Date: Re: ADO and MSSQL authentication
Next by Date: Master / detail with TADODataset?
Previous by thread: ADO Tab Missing
Next by thread: Re: ADO and Blob fields
Index(es):
- Date
- Thread

Relevant Pages

Re: ADO and BLOB
... >I migrating from FoxPro to MSSQL, to reach each of them I use ADO ... >can anybody tell me an example for using the two databases and copy one ...
(borland.public.delphi.database.ado)
ADO and BLOB
... I migrating from FoxPro to MSSQL, to reach each of them I use ADO ... can anybody tell me an example for using the two databases and copy one Blob to the other one? ...
(borland.public.delphi.database.ado)
Re: ADO and Blob fields
... >I migrate from FoxPro to MSSQL and in some cases I had copy 'memo' like ... > field to 'text' type fields. ... I have no problem reading them from the ... If you can read the value with .asString from FoxPro you can write the value to ...
(borland.public.delphi.database.ado)