Devart Forums

Posted: **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.

tia,

JA

Posted: **Wed 08 Jun 2005 07:32**

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

Posted: **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)

Devart Forums

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

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

The memo fields accessing by name