Embedding image in form from subform using HTML GET

Creating and using forms
Post Reply
ctenolophon
Posts: 1
Joined: Thu Aug 21, 2008 3:53 am

Embedding image in form from subform using HTML GET

Post by ctenolophon »

Hi All,

I have a large database (5000+ records) and want to associate an image with each record. Inserting the images into the database itself as binary blobs was not the solution as it led to a huge database file and very slow reaction times. Instead the images are in a directory accessible via a webserver. I can store the URLs of each image as a text field in each record.

What I want to do is create a subform in a general record form, passing to it the URL field for the image from the Main form, and get the subform to query the webserver via a HTML GET, and then display the image as an ImageControl object. I assume from the fill-in fields on the `General' tab of the properties of the subform that this should be possible, but just can't work out how to pass the URL field, and make it do the web query. Has anyone done something like this?

As it happens, it seems that separating out images in this way must be a common solution to incorporating large images into the database. Is there a better way to do it, other than to add them into the hsqldb database directly?

Thanks in advance,

Cam
Post Reply