Display in TDBGrid

[innuendo]

Hi There!

I have:

1. A Table in Oracle database with field:
URL VARCHAR2 (256)
2. A TDBGrid component instance on form of my Delphi application
3. A SQL that cut and select any URL to short look (i.e.

http://www.gu.net/):

select substr(ull.url, 1, decode(instr(ull.url, ''/'', 1), 0, length(ull.url), instr(ull.url, ''/'', 1) - 1))

Program works fine but instead of short URL i see '(MEMO)' in all rows of data grid.
I sure that grid can accommodate cutted data and i want to see this.

What changes i must do in my program that helps?

Many thanks to all!

 

[Svanhooft]

Hi,

In the standard dbGrid it is not possible to view a field of the type Memo. You have 2 possible solutions : Change if possible the type of the field to a string Type, 2 make a Descendant of TDBGRID and implement a method to view fields of the type Memo. Their are a lot of examples on the internet, how to do this. Try

http://www.torry.net.

You will find an component which does exactly what you want.

Steph

 

[innuendo]

Ok, I will look for KADao Controls v.2.2
But can you explain first metod more clearly.

Thanks in advance.