DBGrid Memo Columns ??

[CastleSoft]

See attached picture...

 

How do I stop the uniDBGrid from displaying (WIDEMEMO) or (Memo) for a memo field ?

 

I'd like to display the text contents instead. How do I override this behaviour ?

 

Thanks

Andrew

[Ronak]

select convert(varchar(50), Description) as CalcDescription, convert(varchar(50), Comments) as CalcComments

 

or

 

Add new calculated TStringField and on GetText set the Text

 

procedure TForm1.QryMainCalcDescGetText(Sender: TField; var Text: string; DisplayText: Boolean);

begin

Text:=Copy(Comments,1,50)

end;

[CastleSoft]

Thanks.. Forgot all about the Calculated fields.. Been doing lots of C# stuff lately.