Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Display in TDBGrid

Status
Not open for further replies.

innuendo

Programmer
Joined
Feb 24, 2001
Messages
5
Location
UA
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. 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!
 
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 You will find an component which does exactly what you want.

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

Thanks in advance.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top