Master detail insert error

Guillermo Casta?o A

Delphi Developer

Wed, 17 Mar 2004 01:31:13 GMT

Master detail insert error

Hi, i have a M/D relationship. When i try to insert into the detail a:
'An unknown error has occurred' message appears, but the record IS
inserted.
What can be wrong?
D5 Ent and SQL 7.
thanks
--
Guillermo Casta?o Acevedo
Gerente de Sistemas - Grupo Millennium Ltda
Guiller...@GrupoMillennium.com
www.GrupoMillennium.com

Brian Bushay Team

Delphi Developer

Wed, 17 Mar 2004 11:21:38 GMT

Re:Master detail insert error

Quote

>Hi, i have a M/D relationship. When i try to insert into the detail a:
>'An unknown error has occurred' message appears, but the record IS
>inserted.

Are you using Lookup fields in the table? Does this error only occur when you
run from the IDE? You can ignore the error if the above are true because it is
just do to the way error trapping in ADODB unit is done using some Try/except
blocks.

--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

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 and Master Inserts

4. Generic INSERT error when in a basic master/detail form

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. Master-Detail Query w/Cached Updates requeries Detail when updating single fields in Master

9. update, delete and insert in master detail

10. Inserting new records with Master/Detail relationship and batch updates