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

[Jack Anderson]

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.

tia,

JA

[maciejw]

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

[Ikar]

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)