Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 11 to 17 of 17 total |
"calculated" blob field |
Sun, Jun 30 2013 8:13 AM | Permanent Link |
Adam Brett Orixa Systems | 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. |
Tue, Jul 2 2013 7:16 AM | Permanent Link |
Beni | @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. |
Tue, Jul 2 2013 9:04 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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] |
Tue, Jul 2 2013 1:04 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Tue, Jul 2 2013 2:29 PM | Permanent Link |
Adam Brett Orixa Systems | 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!
|
Wed, Jul 3 2013 4:19 AM | Permanent Link |
Uli Becker | Adam,
please reload your old picture. I liked it: it creates a good mood. No need to be responsive. Uli |
Wed, Jul 3 2013 4:39 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | And since I use an offline reader I don't care
Roy Lambert |
« Previous Page | Page 2 of 2 | |
Jump to Page: 1 2 |
This web page was last updated on Tuesday, May 14, 2024 at 07:14 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |