dbgrid

[Pink-El]

I found that I can to use html as a field`s value and grid`s column will show html result. Very good idea. I can prepare my custom view in query with html for the grid.  How I can insert picture in this code from other field?

Thank you  

[Sherzod]

Hi Dmytro Lendel.

 

You can clarify the issue?

 

If I understand correctly, you want to merge two fields.

 

I think it can be done in the request (you can use stored procedures), and using the function reconfigure (sender, store, columns, oldStore, the, eOpts) in the grid.

 

I'm sorry if I misunderstood ...

 

Sincerely.

[rasaliad]

Hi Lendel,

 

I do it, the same way, using <img> tag, in the database view for the other field i want to display the image.

 

rasaliad

[Pink-El]

Can you give me example, please?

[Pink-El]

Idea is very sipmple

 

Simple query

Select idkey,text from mytable

 

html query

Select '<p>'||cast(idkey as varchar(10))||'</p><p>'||text||'</p>'  as html_info from mytable

 

I can use any html tag and grid will show it correctly. Very nice.

Question was about image. I can use img tag but I need load pict from db filed not from file.

[Ulugbek]

can you share sample?

[Sherzod]

Question was about image. I can use img tag but I need load pict from db filed not from file.

Try to analyze an example:

C:\Program Files\FMSoft\Framework\uniGUI\Demos\Memo and Image in DBGrid

online example: http://prime.fmsoft.net/demo/memoimage.dll

[Pink-El]

Thank you

I saw this demo. I can set some properties of the column and it starts to show image. It`s true. But in my case I need join values from the fields in the single field by html. Source code of the lib is hidden. How I can check it?

[rasaliad]

Lendel

 

As Delphi Developer said you can find the source at:

 

 

C:\DelphiLib\FMSoft93\Framework\uniGUI\Demos\Memo and Image in DBGrid\MemoEdit.dpr

 

rasaliad

[Pink-El]

I found cache folder with img files. Is the file name first 24 chars of the real field value?

[Farshad Mohajeri]

Next version allows custom handling for grid images.