Image on a form

[broche]

Hi All,

Clarion 9.1
Nettalk 8.34

I want to display a photo of a staff member on the staff form.  I have looked at the posts but get a little confused as to the steps to do this.
I see the Image type, do I use that and point at a variable with the path to the photo?

Thanks

[MyBrainIsFull]

See image for steps, on the form
field type is image
the field to display can be from a tps file or a literal (C:\something\adam.jpg)
on the display tab set the image to the field

now you can see thi image and its location on the form

K

[attachment deleted by admin]

[Keith]

Hi

I am trying to display an image that I have successfully stored in a Blob field in a SQLite table.  On the Form I followed MBIF's instructions (I presume that the field Pro:ImageSmall is a Blob) but got a compile error - 'Variable expected' on the Blob field name.

So, is it possible to get the image in the Blob displayed on a Form?  What's missing?

Thanks

Keith

[terryd]

Hi Keith
Off topic a bit but beware of SqlLite if you want to use FM3 to upgrade since Bruce advised me that FM3  doesn't support it.
I looked at SqlLite and thought it would be useful but since I am an inveterate tinkerer as far as databases go this would be a showstopper for me.

[MyBrainIsFull]

Hi Kieth, no my example is not a blob
the handling of a sql table that has a blob is handled in depth in Bruces pdf  "Building Web Applications with NetTalk - Second Edition.pdf"  on pages 74 and 75
"Serving From Blobs "

I dont feel its right to make large extracts from his book without his permission, as the book took him over a week to write.  

The book is found in the Clarion shop

[terryd]

Although I know Bruce likes being called Superman I think that it took an awful lot longer than a week to write ;-)

[Keith]

Hi all responders

I have a copy of 'the book' so no worries there 

What I want to do is to display on a Form the content of a jpg which is stored in a Blob which is what I thought Brian also wants.  Is this possible?

I have watched 4 Webinars (so far) and learned a lot about Blobs and their use but not how to display a photo on a Form (from a Blob)

The main thrust of allowing photos to be uploaded via File Upload is to store the photo in a folder and the full name of the photo file in the database.  I have successfully stored photos and displayed on a Form using that method but wondered if you could do it directly from the Blob - maybe not.

Terry, on the question of SQLite - I was really just experimenting because one of the functions I want to perform is to export a tps table so that another organisation can load it into their own DB (say MSSQL) and I originally achieved that by writing a comma delimited (ASCII) file from tps.  This worked fine but then  'add photos' was suggested so I though that maybe if I stored the photos in SQLite Blobs and just gave them the SQLite DB that they could extract easier from that 'SQL' DB. I'm not wedded to SQLite and take your points.

Second-lastly, it is worth noting that storing photos in a tps file is probably not a good idea because of the 2GB file size limit - that could easily be breached.

Lastly, Brian, displaying staff photos on a form works if the photo is a separate file and you just point to that.

Cheers

Keith

[broche]

Thanks all,
I will use a jpg on the server in a specific location.

Brian.