cannot delete child record in master-detail query

Article View: borland.public.cppbuilder.database.ado

Article #3024

Back to borland.public.cppbuilder.database.ado Previous Next

#3024

From: Gabriel Martinez
Date: Mon, 23 Dec 2002 20:30

6 lines
1369 bytes

i use have an access databse with a select query like this: "SELECT * FROM
TABLE1 INNER JOIN TABLE2 O...", and i use an adoquery to retrieve the
records. the problem is than when executing the delete() function from the
adoquery, it deletes the master record, therefore deleting all child
records. is there a way to make the delete() function just delete de child
record?

Technical Details

Message-ID: <3e0773f8@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-06!sn-xit-09!supernews.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,3a82036c0cf8faa5,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-12-23 12:39:39 PST
From: "Gabriel Martinez" <gabotz@fibertel.com.ar>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: cannot delete child record in master-detail query
Date: Mon, 23 Dec 2002 17:30:31 -0300
Lines: 8
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 24.232.111.213
Message-ID: <3e0773f8@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1040675832 24.232.111.213 (23 Dec 2002 12:37:12 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-06!sn-xit-09!supernews.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail