In my database, I would like to have a field that could hold .peg or .pdf.
I read through various resources on the web and read various pieces of information. Am I correct in my understanding that:
If there is a dedicated web resource on dealing with images in dataview and form view ,please post me the link and I will review it.
Naren17, is it really necessary to hold the jpeg (image) in the database or is it sufficient to simply display the image in the database?
In the olden days, Panorama had a option called Flash Art. These days, the usual method is to store the .jpeg files in one location - say a JpegFolder - and just the path to each image is stored in the database.
That path is used to pull the .jpeg into the appropriate object in a form for display.
designer 17, thank you!
I can live with images in JpegFolder and, pulling the image into a form display. However, how does the workflow work? Do you simultaneously open the datasheet in one window and the form with the image display in another window?
How does Panorama handle .pdf, sound file and video file? Is it the same way, pulling the files through file path into form display?
Thank you!
Yes - that would be one way.
If you were trying to display the photo in the DataSheet view, that’s a horse of a different color. There is no field type for that.
Usually - can’t speak for the PanX world at large - you’d display some list of records, showing the pertinent selection field, and clicking on that list item would make that record “active” and you’d display the rest of the fields on a form.
One way to do that would be to have two windows - like you could have the datasheet, but sized and positioned so you just see the fields you’d use to decide what to select, and a second window next to it that displays the record’s fields you want.
In that Display window, you’d have a object that would show an image (I haven’t worked a lot with images) - it just needs the path to the image. So a field in the record would contain that path.
You could also build a List (object) of records and that list itself would live on the form for a one window solution.
At this point it depends a bit on the nature of your data - number/type of fields and total number of records. Lot’s of paths lead to Rome.
Others are more versed that I on handling those other file types, but I believe it’s the same idea.
Think on this … what “data types” do you have to work with? A field can be Text, Number (integer or float), date, choice or binary. Note that there is no .MOV, .pdf, or AIFF type. But you can store the path to those files and various objects on a form can display/play their content.
Search Help for ‘image’ — you should find everything you need to know. If not, search this forum too because this subject has come up several times recently.
designer, thank you for putting how to add image in PanX into context!
I got the following instructions from Perplexity.ai, which worked nice both for .jpeg and .pdf. These two formats will do me for now>
Thank you, again!
https://www.perplexity.ai/search/how-to-add-image-display-in-pa-QNv_K98LSIGOMq56h1FZbA#0