[DUG] DB grid display of text fields

[Robert Martin]

Hi

Solved it.  It was a setting in our DB components (IBObjects).  If 
anyone is interested

See IB_Session.pas:

{: This global variable sets the limit for a VarChar to be
returned as a ftString FieldType, before it becomes a ftMemo FieldType
in TIBODataSet.}
   MaximumStringSize: Integer = 255;



Rob


On 5/07/2013 9:56 a.m., Robert Martin wrote:
> Hi
>
> We have always known that TDBGrid displays text fields > 254 characters
> as (MEMO) rather than displaying the text.  However we have just moved
> from D2007 to XE2, IBO 4.8 to 5.2 and changed the DB format from
> unspecified to UTF8.  Now fields defined as less than 254 characters are
> showing as (MEMO).  For example one defined as 'only' VarChar(75) shows
> as (MEMO).  I assume that Delphi is using SizeOf for this test rather
> than Length().
>
> I vaguely remember that there was a setting somewhere that could be used
> to change when the (MEMO) is displayed.  Does anyone know where?
>
> Thanks
> Rob
>
> _______________________________________________
> NZ Borland Developers Group - Delphi mailing list
> Post: delphi at listserver.123.net.nz
> Admin: http://delphi.org.nz/mailman/listinfo/delphi
> Unsubscribe: send an email to delphi-request at listserver.123.net.nz with Subject: unsubscribe
>
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2013.0.3345 / Virus Database: 3204/6465 - Release Date: 07/04/13
>
>