Beni

Sorry, but this is reaching the limit of what can be discussed on a forum like this.

I think you have 2 choices:

1. Create a simple function in your delphi EXE. This should take the file-name of the image as a param and return the BLOB of the file. Then write code to iterate your DevEx component and load this BLOB into a field in the grid, or add an additional field to the TDataset descendent which contains your query result and iterate its rows adding the BLOB data.

2. In Delphi create a EDB DLL which runs a FUNCTION which returns a BLOB. It could be called GetPicture(FileName). If you write this FUNCTION you can then write SQL:

SELECT
 Field1,
 FileNameField,
 GetPicture(FileNameField) as PictureBLOB

FROM MyTable

and the PictureBLOB will actually be your picture.

You will need to write the EDB DLL in Delphi, build it as a MODULE then register this module into your database session so that the database can use it.

... I know this sounds hard, but it isn't too bad & once you have built the EDB module/dll you will be able to re-use it with any application that needs it.

@Roy Lambert:
I am unable to locate the examples/template. Could you please point out where exactly should I look for these examples?

@Adam Brett:
Could you please stop replying to my posts, especially when you have nothing to say? Your latest post doesn’t help me – you are telling the same thing as Roy did in an earlier post just made it larger so your picture will fit in. Don’t see any reason why I shouldn’t discuss/ask about User Defined Function on this forum and if I’m asking something that is not supported by the Elevate Team I’m sure that they will point this out.
Since I (more exactly my employer) have paid for the ElevateDB license I am free to ask/discuss any issue I may have. On the other hand I have opened only 2 or 3 threads on this forum so I’m sure that I’m not a burden for the Elevate Team.

Thanks,
Beni.

Beni

>I am unable to locate the examples/template. Could you please point out where exactly should I look for these examples?

In the elevatesoft.public.elevatedb.extensions newsgroup - the fist example of creating an external function (a UDF) is in one of my posts with the subject "external functions"

Naturally it doesn't do exactly what you want but it should give a start point.

>
>@Adam Brett:
>Could you please stop replying to my posts, especially when you have nothing to say? Your latest post doesn’t help me – you are telling the same thing as Roy did in an earlier post just made it larger so your picture will fit in. Don’t see any reason why I shouldn’t discuss/ask about User Defined Function on this forum and if I’m asking something that is not supported by the Elevate Team I’m sure that they will point this out.
>Since I (more exactly my employer) have paid for the ElevateDB license I am free to ask/discuss any issue I may have. On the other hand I have opened only 2 or 3 threads on this forum so I’m sure that I’m not a burden for the Elevate Team.

These newsgroups are peer support with Tim popping in when he has the time. All of Team Elevate are just users, like Team B on the Embarcadero ngs. In general as a community we're friendly and helpful and Tim doesn't censor or moderate the groups. However, if you ask people to stop replying to your posts the chances are that they will, and the rest of us may join in. Adam is trying to be helpful, and he often succeeds. Remember that someone replying to your post may not have seen mine, even if they have and are "simply" restating what's already been posted it can often help to repeat something using different words.

Roy Lambert [Team Elevate]

Beni,

<< Could you please stop replying to my posts, especially when you have
nothing to say? Your latest post doesn’t help me – you are telling the same
thing as Roy did in an earlier post just made it larger so your picture will
fit in. Don’t see any reason why I shouldn’t discuss/ask about User Defined
Function on this forum and if I’m asking something that is not supported by
the Elevate Team I’m sure that they will point this out. >>

Easy now.....

What Adam is pointing out is that you may be better off opening up a support
session for something like this.  You're effectively asking someone to post
a working example of an external module that does what you want.  That is
way up and above what is normally expected here by other users/customers.

<< Since I (more exactly my employer) have paid for the ElevateDB license I
am free to ask/discuss any issue I may have. On the other hand I have opened
only 2 or 3 threads on this forum so I’m sure that I’m not a burden for the
Elevate Team. >>

No one is claiming that you're a burden.  Adam is simply saying that the
support forums are not the correct place for this type of question, and he's
right.  If you want a working example of an external module that loads
images from disk as BLOBs, then please contact support@elevatesoft.com and
open up a support session.  You'll get the in-depth response that you need,
along with the code example that you need.

Tim Young
Elevate Software
www.elevatesoft.com

Sorry my picture uses up so much screen space everyone ... its actually quite a small image, but the newsgroups expand it a bit. I'll load a smaller one!

Adam,

please reload your old picture.  I liked it: it creates a good mood.  No need to be responsive.

Uli

And since I use an offline reader I don't care

Roy Lambert