problem about access and blob field

I want to ask you about a problem between MSAccess and delphi5.
I have a table that contains a blob field and if i put the values of this field, i have this error:

" Handle de BLOB incorrect dans le tampon d'enregistrement"

i use a delphi5 in french version

there is the code containing an error
Table_z_retard.FieldValues['note']:= Table_z_facture_sel.Fields['note'].Value;

the type of these 2 fields are: memo

please help me if you can. thank you very much and if possible give me an example or similar code.

ingenosyaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

kretzschmarCommented:
try following

var m : TMemoryStream;
begin
  m := tmemorystream.Create;
  try
    TBlobField(Table_z_facture_sel.Fieldbyname('note')).SaveToStream(m);
    m.position := 0;
    TBlobField(Table_z_retard.Fieldbyname('note')).LoadFromStream(m);
  finally
    m.free;
  end;
end;

meikl ;-)
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
moduloCommented:
PAQed with no points refunded (of 500)

modulo
Community Support Moderator
0
kretzschmarCommented:
missed the notifiers, (too much notifiers from Dan for reviewing all)
 but my solution IS a VERIFIED working solution!
0
kretzschmarCommented:
well, the PE of this topic am i self ;-)

my opinion is to move the graded answer to my comment above,
a points move is not needed
0
DanRollinsCommented:
The Asker's history consists only of abandoned Qs, so we can't tell much from that -- in this case, it is entirely possible that kretzschmar's comment solved the problem, even without specific verification of the Asker.  

I have no objection to moving the Q into kretzschmar's "Answered" column.  If he had responded to the original ping, I would surely have recommended that the points go to him, too.

-- Dan
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Delphi

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.