Fieldbyname('').Text returns (MEMO) instead of memo contents

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Jack Anderson

Fieldbyname('').Text returns (MEMO) instead of memo contents

Post by Jack Anderson » Tue 07 Jun 2005 22:26

I have Text column type in SQL Server 2000 table and in delphi the code where i have Fieldbyname('').Text it returns a (MEMO) instead of the row contents, this worked fine in Interbase.

Anyone have any workarounds besides FieldbyName('')asString or FieldByName('').Value ?

This is a Midas app, is there a switch in TMSQuery or TDataSetProviders to do it in one place rather than attempt to do a massive search and replace.



Posts: 11
Joined: Sun 20 Mar 2005 10:37
Location: Poland

The memo fields accessing by name

Post by maciejw » Wed 08 Jun 2005 07:32

The memo field can be assessed by TMemoField(TableName.FieldByName('FieldName')).As....

Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by Ikar » Thu 09 Jun 2005 12:26

It is a normal behaviour for BLOB fields. You can see details in Delphi help or in the source code of VCL (unit DB.pas)

Post Reply