Blob fields

Troels Kjerulf

Delphi Developer

Fri, 27 Oct 2000 03:00:00 GMT

Blob fields

Does anyone now, why im having trouble with this operation:

Myset.edit
MyDataSource.Mytable.fieldbyname('MyMemoField'):=Tmemo1.text;
Myset.post

Error: Can't perform this operation at a blob field....

This is Delphi 3, and MS Access 97 using ODBC.

Thanks

Troels Kjerulf

Karlheinz Sp?t

Delphi Developer

Fri, 27 Oct 2000 03:00:00 GMT

Re:Blob fields

Troels Kjerulf schrieb in Nachricht <6j7m9n$8...@forums.borland.com>...

Quote

>Does anyone now, why im having trouble with this operation:

>Myset.edit
>MyDataSource.Mytable.fieldbyname('MyMemoField'):=Tmemo1.text;
>Myset.post

>Error: Can't perform this operation at a blob field....

Try: MyDataSource.Mytable.fieldbyname('MyMemoField').AsString :=Tmemo1.text;

If this does not work, try to use blobstreams.

Karlheinz Spaeth

Wayne Herber

Delphi Developer

Fri, 27 Oct 2000 03:00:00 GMT

Re:Blob fields

I think you need to use the Assign operator as in:

MyDataSource.Mytable.fieldbyname('MyMemoField').Assign(Tmemo1.text);

Quote

Troels Kjerulf wrote:
> Does anyone now, why im having trouble with this operation:

> Myset.edit
> MyDataSource.Mytable.fieldbyname('MyMemoField'):=Tmemo1.text;
> Myset.post

> Error: Can't perform this operation at a blob field....

> This is Delphi 3, and MS Access 97 using ODBC.

> Thanks

> Troels Kjerulf

--
Wayne Herbert
Manager, Computer Products
Key Maps, Inc.
1411 West Alabama
Houston, TX 77006

Vox: 713.522.7949
Fax: 713.521.3202
Email: wherb...@rice.edu

"Why is it only drug dealers and software developers call their clients
'users'?"

Thibault Geurt

Delphi Developer

Fri, 27 Oct 2000 03:00:00 GMT

Re:Blob fields

Try the ASSIGN function to put your memo text in your field

My DataSource.MyTable.fieldbyname('mymemofield').assign(Tmemo1.text);

I'm sure that you can find a solution with this idea......

Thibault

Quote

Troels Kjerulf wrote in message <6j7m9n$8...@forums.borland.com>...
>Does anyone now, why im having trouble with this operation:

>Myset.edit
>MyDataSource.Mytable.fieldbyname('MyMemoField'):=Tmemo1.text;
>Myset.post

>Error: Can't perform this operation at a blob field....

>This is Delphi 3, and MS Access 97 using ODBC.

>Thanks

>Troels Kjerulf

Brian Bushay Tea

Delphi Developer

Sat, 28 Oct 2000 03:00:00 GMT

Re:Blob fields

Quote

>I think you need to use the Assign operator as in:

>MyDataSource.Mytable.fieldbyname('MyMemoField').Assign(Tmemo1.text);

I belive you need
MyDataSource.Mytable.fieldbyname('MyMemoField').Assign(Tmemo1.lines);

--
Brian Bushay (TeamB)
Bbus...@DataGuidance.com

Wayne Herber

Delphi Developer

Sat, 28 Oct 2000 03:00:00 GMT

Re:Blob fields

Quote

Brian Bushay TeamB wrote:
> >I think you need to use the Assign operator as in:

> >MyDataSource.Mytable.fieldbyname('MyMemoField').Assign(Tmemo1.text);

> I belive you need
> MyDataSource.Mytable.fieldbyname('MyMemoField').Assign(Tmemo1.lines);

Details, details!!! :>)

--
Wayne Herbert
Manager, Computer Products
Key Maps, Inc.
1411 West Alabama
Houston, TX 77006

Vox: 713.522.7949
Fax: 713.521.3202
Email: wherb...@rice.edu

"Why is it only drug dealers and software developers call their clients
'users'?"

Other Threads

1. Problem inserting blob field into another blob field using two ibsql

2. BLOB error while not using BLOB fields

3. Saving TMemo field data to a Blob field (Interbase Table) via SQL Update Query

4. Field not a BLOB field

5. Storing Memo fields in Databases (Blob Fields?)

6. How to save a richedit text (with formatting) in a Paradox-Database field (blob field)

7. How to save a richedit text (with formatting) in a Paradox-Database field (blob field)

8. save a bitmap to a blob field (OLE field)

9. How to define which BLOB field is Text and which BLOB field is image?

10. Copying data from Clipboard into a Blob Field