Re: ADO/Delphi6/MsAccess - Memofields ..SOLVED
From: Jim Gabriel (kbsc_at_earthlink.net)
Date: 01/19/04
- Next message: Marlin: "LoginPrompt - dialog box"
- Previous message: M.Sameer: "Re: Problem with Jet 4 and Access Database"
- In reply to: Jim Gabriel: "ADO/Delphi6/MsAccess - Memofields with imbedded objects not accessable"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
>
>
>
- Next message: Marlin: "LoginPrompt - dialog box"
- Previous message: M.Sameer: "Re: Problem with Jet 4 and Access Database"
- In reply to: Jim Gabriel: "ADO/Delphi6/MsAccess - Memofields with imbedded objects not accessable"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
