Hi Ken, There is now that funny thing called BLOB-Field. Your advice was relevant for those dark times where we only had that General fieldtype. Now, the BLOB is a Memofield like the General-Field, but it just stores Binary data without any OLE-Information. You basically write the picture-file content into that field, therefor you can always restore it to a real picture file or just bind it to the PictureVal property of an ImageControl.
Create table Pictures (title C(50), content W) Insert into Pictures (title, content) Values ("My Picture", GetPict("JPG") )
On your form you just add an image control and set Pictureval = "Pictures.content")
-----Ursprüngliche Nachricht----- Von: ProFox profox-bounces@leafe.com Im Auftrag von Ken Watkins Gesendet: Montag, 15. August 2022 20:36 An: ProFox Email List profox@leafe.com Betreff: Pictures in a table
Hi ProFoxers.
I haven't posted in a decade or two, but I'm still hanging around.
I am writing an app for my son to manage his business. He's a therapist and routinely jots down notes on a small notepad during his client sessions. He later adds typewritten notes into the client record but he also takes a picture of his handwritten notes and copies/pastes it into the client record. He's been using OneNote to accomplish this but he wants to move away from that. So I started my app and it creates the client records and the memo fields needed for the notes but I can't figure out what to do with the picture.
Now I know that the standard advice is "do not store the picture in a General field, store the path to the picture..." But I'm wondering if there is a device or third party app that I could use to link the picture to the client record. I even thought about him using a tablet with an electronic pen to store his scribblings and somehow tie that into my Foxpro table.
Just looking for ideas on how to incorporate images with Foxpro records elegantly.
Thanks.
Ken Watkins
-- This email has been checked for viruses by Avast antivirus software. www.avast.com
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---
[excessive quoting removed by server]