Subject Varchar(500) to ftMemo ?
Author Edson Luis Gonçalez
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 !"


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.391 / Virus Database: 222 - Release Date: 19/09/2002