[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 272
  • Last Modified:

Memos & Images in MS Access?

Using Delphi 7, MS ACCESS  & ADO ( using No Data aware controls at all)

I have two Memo (memShortDesc, memLongDesc)

I need to be able to do a Insert and place the lines from my memos into the table's fields  (ShortDesc, LongDesc) - Note : fields are of type Memo
I also need to be able to retrieve memo lines from table and plave in Memo controls.

I also have 1 Image  (imgMain)

I need to be able to do a Insert and place the image (bitmap)  into the table's field (Image) Note : field  is of type OLE Object
I also need to be able to retrieve the bitmap from the table and place in image control

How do I do this?

1 Solution
as loas as you don't need to access the fields with the access frontend,
you can store your image like

TBlobField(Dataset.FieldByName('Image')).LoadFromFile(FileName);// or loadfromstream

TBlobField(Dataset.FieldByName('Image')).SaveToFile(FileName);// or SaveToStream

similar you can work with your memos.
in case of memos you could also use the dbaware-component TDBMemo

meikl ;-)

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now