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

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.

0
ingenosya
Asked:
ingenosya
  • 3
1 Solution
 
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
 
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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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