how to update only one table in a dataset which includs two or more tables?

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

Article #2894

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

#2894

From: NEO
Date: Thu, 27 Feb 2003 02:53

10 lines
1347 bytes

After I retrive data by a select statement as below:

                select EmpName,DepartmentName
                       from employee,department
                       where employee.dp = department.id

How to update only employee table instead of department?

I use ADOQuery, it's intelligent so much that it keeps updating both tables
each time I try to update employee table.

Technical Details

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

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!newshosting.com!news-xfer2.atl.newshosting.com!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!news.kweb.on.ca!KWeb!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,7b59da6a7891e6bf,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-02-26 18:57:12 PST
From: "NEO" <glin@gri-china.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: how to update only one table in a dataset which includs two or more tables?
Date: Thu, 27 Feb 2003 10:53:13 +0800
Lines: 12
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
NNTP-Posting-Host: 218.75.47.186
Message-ID: <3e5d7dcf@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1046314447 218.75.47.186 (26 Feb 2003 18:54:07 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!newshosting.com!news-xfer2.atl.newshosting.com!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!news.kweb.on.ca!KWeb!newsgroups.borland.com!not-for-mail