Displaying BLOB field in DBGrid

[Sugiharto]

I have some BLOB fields in my database. When I display them in a DBGrid,
they showed as MEMO instead of their real value (text/graphic).
Is it possible to show BLOB fields value in DBGrid?

Sugiharto

[Jeff Overcash (TeamB)]

Post by Sugiharto
I have some BLOB fields in my database. When I display them in a DBGrid,
they showed as MEMO instead of their real value (text/graphic).
Is it possible to show BLOB fields value in DBGrid?

No. Some third party grids will do this (both InfoPower and DevExpress) but the
standard DBGrid will not.

Post by Sugiharto
Sugiharto

[Wayne Niddery [TeamB]]

Post by Sugiharto
I have some BLOB fields in my database. When I display them in a
DBGrid, they showed as MEMO instead of their real value
(text/graphic).
Is it possible to show BLOB fields value in DBGrid?

You can use the OnGetText event of the memo field to set the displayed text
to the memo contents, but of course you have to contend with the limited
room in the grid cell.

[Sugiharto]

Where is the OnGetText event? I can't find it, is it part of the grid or
somewhere else?

Post by Wayne Niddery [TeamB]
You can use the OnGetText event of the memo field to set the displayed text
to the memo contents, but of course you have to contend with the limited
room in the grid cell.

[Jeff Overcash (TeamB)]

Post by Sugiharto
Where is the OnGetText event? I can't find it, is it part of the grid or
somewhere else?

Persist the TFields. It is a TField event.

[Sugiharto]

I found it, under the FieldByName(X).OnGetText, but I can't understand how
to use it, can you explain a little?
I read the help but still don't understand.

Post by Wayne Niddery [TeamB]

Post by Sugiharto
I have some BLOB fields in my database. When I display them in a
DBGrid, they showed as MEMO instead of their real value
(text/graphic).
Is it possible to show BLOB fields value in DBGrid?

You can use the OnGetText event of the memo field to set the displayed text
to the memo contents, but of course you have to contend with the limited
room in the grid cell.
--
Wayne Niddery - Logic Fundamentals, Inc. (www.logicfundamentals.com)
RADBooks: http://www.logicfundamentals.com/RADBooks.html
"It is error alone which needs the support of government. Truth can
stand by itself." - Thomas Jefferson

[Wayne Niddery [TeamB]]

Post by Sugiharto
I found it, under the FieldByName(X).OnGetText, but I can't
understand how to use it, can you explain a little?
I read the help but still don't understand.

procedure MyForm.MyTableSomeMemoGetText(Sender: TField;
var Text: String; DisplayText: Boolean);
begin
Text := Sender.AsString;
end;

Create the OnGetText event for the memo field. The single line of code above
should work there.

[Nestor]

Hi :

You may try a third party grid like TJfDBGrid of JfControls at
www.jfactivesoft.com. But if ypu want to do this by your own:
- Load the Blob field into a TMemoryStream.
- Use the VCL TIMage and draw it inside the cell. There is an OnDrawCell
event or something like that. The image will appear small.
- Use any mouse event to catch a click, and show another TImage. Use the
memory stream to do that.

Anyway, if you are a newbie, I advice you to use a third party solution like
JfControl.

Best regards...

Nestor

Post by Sugiharto
I have some BLOB fields in my database. When I display them in a DBGrid,
they showed as MEMO instead of their real value (text/graphic).
Is it possible to show BLOB fields value in DBGrid?
Sugiharto