Access Blob handles with memo fields

J_MAKIN

Delphi Developer

Sat, 02 Jan 1999 03:00:00 GMT

Delphi/Access Blob handles with memo fields

I sent to this to the Delphi Knowledge base but haven't had any
answer yet. Can anyone help? ...

Topic: BDE
Keywords: Access, ODBC, Blob handle, Delphi 2.0

I cannot insert a new memo fields contents into an Acces database.
Access is linked to the BDE via ODBC(32).
I have a (select) query over just one table which returns a live result
set from Access. Calling insert sets the query into insert mode and
everything seems fine.
I can write text to my hearts content into all the (db)edit fields
including the one (db)memo field returned from the query.
When I call post I get a EDBEngineError - Invalid BLOB handle. BUT
this only happens if I have entered text into the memo field.
Trying the same thing with a datasource linked to a table produces a
different error message under the same circumstances. EDBEngineError
- Record/Key deleted.
I can't find any documentation on these facts and the manuals don't
refer to ODBC. The only piece of information I could find was in the
Access on-line help which says that SQL doesn't support BLOB fields.
Could this be part of the problem, or the whole problem?

Help!

j_ma...@oscarfab.demon.co.uk
Oscar Faber-Water Division, Marlborough House, Upper Marlborough Rd,
St. Albans, Herts. AL1 3UT.

Michael Sahl Jense

Delphi Developer

Fri, 08 Jan 1999 03:00:00 GMT

Re:Delphi/Access Blob handles with memo fields

Quote

J_MAKIN wrote:

> I sent to this to the Delphi Knowledge base but haven't had any
> answer yet. Can anyone help? ...

> Topic: BDE
> Keywords: Access, ODBC, Blob handle, Delphi 2.0

> I cannot insert a new memo fields contents into an Acces database.
> Access is linked to the BDE via ODBC(32).
> I have a (select) query over just one table which returns a live result
> set from Access. Calling insert sets the query into insert mode and
> everything seems fine.
> I can write text to my hearts content into all the (db)edit fields
> including the one (db)memo field returned from the query.
> When I call post I get a EDBEngineError - Invalid BLOB handle. BUT
> this only happens if I have entered text into the memo field.
> Trying the same thing with a datasource linked to a table produces a
> different error message under the same circumstances. EDBEngineError
> - Record/Key deleted.
> I can't find any documentation on these facts and the manuals don't
> refer to ODBC. The only piece of information I could find was in the
> Access on-line help which says that SQL doesn't support BLOB fields.
> Could this be part of the problem, or the whole problem?

> Help!

> j_ma...@oscarfab.demon.co.uk
> Oscar Faber-Water Division, Marlborough House, Upper Marlborough Rd,
> St. Albans, Herts. AL1 3UT.

I can't give you the answer to your proplem, but try to place the Acess
Database in a directory with a path without long filenames. It sounds
crazy but i had a lot of trouble ( I got an "Opertion invalid at this
time" ODBC Error when i tried to edit existing records), which
disappeared when i moved the Database. It's worth a try.

regards

Other Threads

1. Memo Fields in Access and Memo object in Delphi

2. Non - Blob column in table required to perform operation - DBMemo ( Field Type Memo) With Access

3. Access and Blob/Memo Fields

4. Access text field changed (in Delphi) into memo field

5. Delphi accessing MS Access Memo Fields

6. Storing Memo fields in Databases (Blob Fields?)

7. Access 97, Delphi 3.02 and the Memo field ...

8. Delphi 2.0, Access ODBC & Memo field

9. Q: Memo fields Delphi 1 using MS Access 2.0 tables through ODBC

10. Garbage in Memo Fields - Delphi and M$ Access and ODBC