ADO/Delphi6/MsAccess - Memofields with imbedded objects not accessable

From: Jim Gabriel (kbsc_at_earthlink.net)
Date: 01/16/04

  • Next message: Bruce Roberts: "Re: TStringGrid and TInplaceEdit" 
    Date: Fri, 16 Jan 2004 13:46:37 -0800

    I have a Delphi6 app using ADO to connect to a local MsAccess table. Some
    fields are memo fields (defined in Access) which contain RTF data. A
    different applicaton that was using DAO popluated these fields.

    I'm using ADOdatasets to using the commandtext to select the fields.

    OldDatabase.ADOPatientDetail.Close;
    OldDatabase.ADOPatientDetail.CommandText := 'select * from PatientTable
    where PatientCode= ''' + PtCode + '''';
    OldDatabase.ADOPatientDetail.Open;

    When the program gets to 'OPEN'ing the table, it hangs. I know the memo
    field contains a bitmap image along with text (RTF) but I have no idea how
    to retrieve ALL this data without it hanging.

    When I use the program that had populated that field using DAO, the data is
    fine.

    What can I do to retrieve the data using ADO?
    Jim

  • Next message: Bruce Roberts: "Re: TStringGrid and TInplaceEdit"