Click TDBGrid cell and display memo/blob record

Posted on 1999-08-01
Medium Priority
Last Modified: 2008-02-26
I am using Delphi 3 with a TDBGrid component, whose datasource is a Paradox table.  In this table is a Memo field of a memo/blob type.  At run time, the column representing this memo/blob field displays a little page icon.  Clicking on this cell does nothing.


How does one detect when this particular cell has been clicked on, and how do I display the contents of this memo/blob field from the TDBGrid?
Question by:Monroe406
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
LVL 27

Accepted Solution

kretzschmar earned 90 total points
ID: 1392358
hi Monroe406,

use a second form, place there a tdbmemo (alclient) connect it it with your dataset of your form1 and the blobfield. this will show now allways the memocontent of the current record.

to show this form by doubleclick on the dbgrid-field use

procedure TForm1.DBGrid1DblClick(Sender: TObject);
  IF DBGrid1.SelectedField.FieldName = 'MyMemoFieldName' then


Author Comment

ID: 1392359
I have done as you have said...but it does not work.

The Form2 does appear, but the contents of the TDBMemo is blank.

My table does indeed have memo/blob fields with data in it, however that data is not showing up in the Form2.Show.

Yes, I have associated the TDBMemo.DataField to the corresponding table's field.

P.S. you failed to mention that I needed to drop a TTable and TDataSource component on the form.  I went ahead and did this, assuming you assumed I knew this.
LVL 27

Expert Comment

ID: 1392360
hi Monroe406,

> you failed to mention that I needed to drop a TTable and TDataSource
>  component on the  form.

no that meant i not, use the  tdatasource of your form1, where the dbgrid is connected to it.

to do this, add after the implementation-keyword of your form2-unit :

uses TheNameOfYourForm1-Unit;

the datasourcename of the tdbmemo is :
Form1.Datasource1; //if it so named by yours

please try again


Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Objective: - This article will help user in how to convert their numeric value become words. How to use 1. You can copy this code in your Unit as function 2. than you can perform your function by type this code The Code   (CODE) The Im…
Creating an auto free TStringList The TStringList is a basic and frequently used object in Delphi. On many occasions, you may want to create a temporary list, process some items in the list and be done with the list. In such cases, you have to…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Suggested Courses

719 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question