problem about access and blob field

Posted on 2004-11-11
Last Modified: 2012-08-14
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.

Question by:ingenosya
    LVL 27

    Accepted Solution

    try following

    var m : TMemoryStream;
      m := tmemorystream.Create;
        m.position := 0;

    meikl ;-)

    Expert Comment

    PAQed with no points refunded (of 500)

    Community Support Moderator
    LVL 27

    Expert Comment

    missed the notifiers, (too much notifiers from Dan for reviewing all)
     but my solution IS a VERIFIED working solution!
    LVL 27

    Expert Comment

    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
    LVL 49

    Expert Comment

    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

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    In this tutorial I will show you how to use the Windows Speech API in Delphi. I will only cover basic functions such as text to speech and controlling the speed of the speech. SAPI Installation First you need to install the SAPI type library, th…
    Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    728 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

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now