Solved

Reading/writing TBitmaps to an MS Access table

Posted on 2002-04-09
4
133 Views
Last Modified: 2010-04-04
I need to store the contents of a TImage to my MS Access table. I need one procedure for loading data and one for saving data. The only type Access seems to have for binary data is "OLE Object". I don't have the slightest clue on how to do this.

Please help!


regards,
Johan Sageryd
0
Comment
Question by:sageryd
  • 2
  • 2
4 Comments
 
LVL 27

Accepted Solution

by:
kretzschmar earned 200 total points
ID: 6927645
yep,

access stores blobs with an ole-server information prefix.

if there is no need to access the content within the access-frontend, then you should be able to store your images simple with

tblobfield(dataset.fieldbyname('fieldname')).loadfromfile('filename');  //or loadfromstream

savetofile/savetostream for the other direction

if your images are from different graphicformat, you need also a typefield in your table

meikl ;-)
0
 
LVL 1

Author Comment

by:sageryd
ID: 6927656
Just discovered that on my own :)  Thanks anyway Meikl!!
0
 
LVL 27

Expert Comment

by:kretzschmar
ID: 6927668
well, glad you got it works,
thanks for the points :-)
0
 
LVL 1

Author Comment

by:sageryd
ID: 6927676
;)

Thanks again


I'm making a program for teaching japanese. I recon I might be able to sell it to my school. :)
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article explains how to create forms/units independent of other forms/units object names in a delphi project. Have you ever created a form for user input in a Delphi project and then had the need to have that same form in a other Delphi proj…
Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question