detail form

Bruce

Delphi Developer

Fri, 26 Jul 2002 03:00:00 GMT

Generic INSERT error when in a basic master/detail form

I have a REAL generic master detail form with a TADOConnection, TADOQuery,
and the norma db nav, datasource, and dbedit controls. All I want to do is
click the + sign in the nav and insert a record against my SQL server table.
But at the time of posting the INSERT, I always get the generic EOle...
"errors occurred" message. Updates and deletes work fine.

If I change the lock type to batch optimisitic, the insert seems to work,
but the updates and deletes don't. What is going on? This app has no code,
just the controls.

TIA, Bruce

Other Threads

1. Master/Detail w/SQL Server shows all detail records when inserting a new master record

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

3. Master detail insert error

4. Master Detail and Master Inserts

5. Problem when inserting records in the detail table (master/detail relation)

6. Master detail detail, cached updates, and insert/delete

7. Inserting detail in master/detail grids

8. EOF error in master/detail form

9. Access violation error on master detail form.

10. Master/Detail Form - Error: Cannot Focus a disabled or invisible window