Use persistent fields and change it to a TStringField.
By default strings over 255 in length are handled by a TMemoField for
reasons of how MIDAS deals with them. It also seems most likely that the
text in there will be more of text than a string.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

-- We may not have it all together --
-- But together we have it all --

----- Original Message -----
From: "Edson Luis Gonçalez" <edson@...>
To: <ibobjects@yahoogroups.com>
Sent: Friday, September 27, 2002 10:00 AM
Subject: [IBO] Varchar(500) to ftMemo ?


> Hello,
>
> I have a table ELG_TAB_ERRO in the database, the fields are:
>
> ID INTEGER NOT NULL (PK)
> VLR VARCHAR(60) NOT NULL
> DESCR VARCHAR(500) NOT NULL
>
> I have 1 form (generic search form for all sql statement) called by
function
> and receiving parameters like sql text,
> the form have 1 TIBOQuery like this SQL statement (for example):
>
> select vlr,
> descr
> from elg_tab_erro
> order by 1
>
> And others components like 1 TDBGrid, 1 DataSource, buttons and edit .
>
> The problem is:
>
> The field descr was explicitly converted to ftMemo, and in the DBGrid
> appears only the description '(MEMO)', ?!?!?!?
>
> I don't understand... the field VLR was displayed ok, but field DESCR is
> converted :-(
>
> Other problem is, when i use a UDF function in select statement the string
> return as blob (ftMemo), why ?
>
> Please, sorry for my english, and i stand by for any sugestions or
solutions
> to solve my problem.
>
> Status: Delphi 6, IBO 4 (dataset compatible), Firebird 1.0
>
> Thanks
>
> ---------------------------------------------------------------
> Edson Luis Gonçalez - Ribeirão Preto / SP / Brasil
> Membro da Comunidade Firebird de Língua Portuguesa
> http://www.comunidade-firebird.org - "Onde o Firebird fala Português !"