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-boun...@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]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message:
https://leafe.com/archives/byMID/023901d8b14f$89f4e390$9ddeaab0$@wondzinski.de
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
