Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread Handling external files C/S
Mon, Apr 15 2013 10:17 AMPermanent Link

Brent Shelton

This may be a simple question.  I want to upgrade to the C/S version but I'm not sure how to handle something.  My application has images and documents that are in the database folder and not in tables.  How do I display those images and documents to remote users?  

In the past I have been just appending the path to the DBISAMDatabase1.Directory

Thanks!
Wayne
Tue, Apr 16 2013 9:10 AMPermanent Link

Fernando Dias

Team Elevate Team Elevate

Wayne,

I'm afraid it's not as simple... or it can be if you do it the same way you do it now, that is, you would have all the images in a shared folder and get them from there as you do now, all the rest would be C/S.
If you want it all to go C/S then a possible way would be to setup a web server and get the images via http, having the urls in the database, or if it's not many gigabytes, store all the images in the database using blob fields.

Fernando Dias
[Team Elevate]
Wed, Apr 17 2013 9:37 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Wayne,

<< This may be a simple question.  I want to upgrade to the C/S version but
I'm not sure how to handle something.  My application has images and
documents that are in the database folder and not in tables.  How do I
display those images and documents to remote users? >>

You can create a server-side procedure to handle this.  Please read the
"Server Procedures" section of the manual here:

http://www.elevatesoft.com/manual?action=viewtopic&id=dbisam4&product=delphi&version=7&topic=Customizing_Engine

for information on how to create a custom server procedure on the server
side.  To do this using the provided DBISAM Database Server, you would
modify the dbsrvr.dpr project in the \servers\dbsrvr\source subdirectory
under the main installation directory.

This section of the manual shows how you would call such a procedure:

http://www.elevatesoft.com/manual?action=viewtopic&id=dbisam4&product=delphi&version=7&topic=Calling_Server_Procedures

So, effectively you would have a server procedure that accepts some
parameters regarding which image/document that the client wants, and then
the server procedure would then populate a result parameter containing the
requested image/document.  The remote session can then save that data from
the parameter to a file using the SaveToFile method:

http://www.elevatesoft.com/manual?action=viewmethod&id=dbisam4&product=delphi&version=7&comp=TDBISAMParam&method=SaveToFile

If you have any other questions, please let me know.

Tim Young
Elevate Software
www.elevatesoft.com
Image