Board index » delphi » Problems Using Query Component to Change Data in Master/Detail Tables

Anthony Magauran

Delphi Developer
Fri, 27 Apr 2001 03:00:00 GMT

Problems Using Query Component to Change Data in Master/Detail Tables

After using Query components to change the data in the tables underlying a
Master/Detail relationship, I get spasmodic Beginning of Table and End of
Table error messages.  I have tried refreshing the tables, opening and
closing them, and turning filters on and off without completely eliminating
the problem.

Any other suggestions would be appreciated.

I am using D4 and Access.

 
Frank Fortin

Delphi Developer
Mon, 07 May 2001 03:00:00 GMT

Re:Problems Using Query Component to Change Data in Master/Detail Tables


Hi,

Use Master/Detail for viewing data only.

Edit and update your Tables (databases) separately,
with TTables without M/D property.

Master/Detail limits you in your access to your data.

It's great for viewing, but can cause you a lot of headaches.

Frank
----------------------------------------

Quote
Anthony Magauran wrote:

> After using Query components to change the data in the tables underlying a
> Master/Detail relationship, I get spasmodic Beginning of Table and End of
> Table error messages.  I have tried refreshing the tables, opening and
> closing them, and turning filters on and off without completely eliminating
> the problem.

> Any other suggestions would be appreciated.

> I am using D4 and Access.

Other Threads

1. Crash in data aware components when using lookup field in Master-Detail table

2. Master-detail: changing detail table

3. Master-Detail Query w/Cached Updates requeries Detail when updating single fields in Master

4. TDBGrid problem with display of detail data in master:detail system

5. master/detail refresh problem using tado tables

6. Critical problem using Master-detail with large tables

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

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

9. Locate in Master/Detail tables causes Detail table to fail

10. Master/Detail param data type changes?