Subject | Varchar(500) to ftMemo ? |
---|---|
Author | Edson Luis Gonçalez |
Post date | 2002-09-27T17:00:05Z |
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
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