Re: ADO/Delphi6/MsAccess - Memofields ..SOLVED

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

Date: Mon, 19 Jan 2004 10:06:14 -0800

Absolutely frustrating.... The problem was the table that contained the data
in which I was reading was a Access97 table and the memo fields were > 64K.
ADO doesn't like that in a SQL statement. So, I read the data OUT of the
Access97 table using a DAO connection and then copy the contents into an ADO
table (Access2000 table). Now, doing a SQL select on the ADO table works
PERFECTLY.

"Jim Gabriel" <kbsc@earthlink.net> wrote in message
news:40085bbc$1@newsgroups.borland.com...
> 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
>
>
>

Relevant Pages

  • Re: Unbound text box, text>255, MS Access/PostgreSQL
    ... >text box using parameter of DAO QueryDef object. ... so that Access links PostgreSQL Text fields as Memo fields in ... >pass text from UNBOUND control to the linked table by using DAO or ADO ...
    (comp.databases.ms-access)
  • Unbound text box, text>255, MS Access/PostgreSQL
    ... There is a DAO Append Query that has a parameter that is passed from the ... so that Access links PostgreSQL Text fields as Memo fields in ... pass text from UNBOUND control to the linked table by using DAO or ADO ... Memo field of linked PostgreSQL table, by using DAO or ADO? ...
    (comp.databases.ms-access)
  • Re: problem with WHERE clause when using ADO and Microsoft.Jet.OLEDB.4
    ... I am using ADO with Microsoft.Jet.OLEDB.4.0 to connect to the Access97 ... also had tried to convert the database from Access97 to Access2000 ... This email account is my spam trap so I ...
    (microsoft.public.data.ado)
  • ADO/Delphi6/MsAccess - Memofields with imbedded objects not accessable
    ... I have a Delphi6 app using ADO to connect to a local MsAccess table. ... fields are memo fields which contain RTF data. ... What can I do to retrieve the data using ADO? ...
    (borland.public.delphi.database.ado)
  • Re: problem with WHERE clause when using Microsoft.Jet.OLEDB.4.0
    ... I am using ADO with Microsoft.Jet.OLEDB.4.0 to connect to the Access97 ... is Index Yes with Duplicates OK, ... ADORecordset error, error code =80004005, code meaning = Unspecified error ... to convert the database from Access97 to Access2000 and upgrade the ADO ...
    (microsoft.public.access.queries)