Board index » delphi » MS-Access 97 Master/Detail form problem

Geoff Ford

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

MS-Access 97 Master/Detail form problem

When I try to create a Master/Details form using an Access97 DB with the
linking field being an AutoNumber in the Master table I get this runtime
error:-

"Project........raised exception class EDBEngineError with message
'Non-blob' column in table required to perform operation"

Is there a way to create this Master/Detail form without changing the
linking field from an AutoNumber to a long int?

 
Esa Rai

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:MS-Access 97 Master/Detail form problem


On Mon, 02 Mar 1998 21:47:10 +1000, Geoff Ford

Quote
<gf...@scs.brisnet.org.au> wrote:
>When I try to create a Master/Details form using an Access97 DB with the
>linking field being an AutoNumber in the Master table I get this runtime
>error:-

>"Project........raised exception class EDBEngineError with message
>'Non-blob' column in table required to perform operation"

>Is there a way to create this Master/Detail form without changing the
>linking field from an AutoNumber to a long int?

Are you sure your problem is related to the Autonumber field? I've
only played with the idea of converting one of my Access projects to
Delphi but I did test the functionality of the MSACCESS driver with a
similar setup and had no problems.
Geoff For

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:MS-Access 97 Master/Detail form problem


Quote
Esa Raita wrote:
> On Mon, 02 Mar 1998 21:47:10 +1000, Geoff Ford
> <gf...@scs.brisnet.org.au> wrote:

> >When I try to create a Master/Details form using an Access97 DB with the
> >linking field being an AutoNumber in the Master table I get this runtime
> >error:-

> >"Project........raised exception class EDBEngineError with message
> >'Non-blob' column in table required to perform operation"

> >Is there a way to create this Master/Detail form without changing the
> >linking field from an AutoNumber to a long int?

> Are you sure your problem is related to the Autonumber field? I've
> only played with the idea of converting one of my Access projects to
> Delphi but I did test the functionality of the MSACCESS driver with a
> similar setup and had no problems.

I have defined the linking field in the Master table as a long int and have
no problems.   I want to keep the field as an autonumber field to create a
unique key  with out having to code it to assign a unique key.

Thanks.

Other Threads

1. Problem with Master/Detail Form & Access 97

2. D5-ADO-MS ACCESS 97 database-MS Office 97 Access ODBC driver-Autoincrement probs

3. Access 97 and BDE 4.51 master-detail

4. Problem with MS Access 97 database, accessed by group of users

5. Use MS ACCESS 97 BDE drivers for MS ACCESS 2000

6. Native MS Access 97 connection when MS Access 2K is installed on PC

7. Delphi 4 + Native Ms Access 97 driver + MS Access queries

8. BDE 4.51 Problem - Detail Records Disappear in a Master-Detail Form

9. Problem: Master/Detail shows details during Master Insert

10. Problem reading paradox table in MS Access 97