Re: How best can I do this?

Article View: borland.public.cppbuilder.database.multi-tier

Article #230

Back to borland.public.cppbuilder.database.multi-tier Previous Next

#230

From: Nick Rambarransingh
Date: Fri, 13 Aug 2004 18:27

28 lines
1832 bytes

Good Day,

  you could write something like this:

Select * from DS1
where ds1_KeyField in 
  (Select DISTINCT ds2_KeyField from DS2 order by ds2_KeyField)

HTH,
Nick

"Sreekanth Reddy Bandi" <sreekanth_reddy@persistent.co.in> wrote:
>Hi,
>
>I have two datasets..DS1, DS2. DS2 has 16 cols and has about 50k rows
>fetched from remote database and cached in memory using TClientDataSet.
>Initially DS2 is shown to the user in the grid. DS2 contains one column(this
>column is present in DS1 also) and its size varies from 1 row to few hundred
>rows. On certain events, DS2 is constructed afresh. Now I would like to see
>only those records of DS1 that are present in DS2 also. In other words DS1
>holds details of the records held in DS2. Each time DS2 is
>constructed/refreshed, I would like to see the details in DS1.
>
>Thanks in advance,
>Sreekanth
>
>

Technical Details

Message-ID: <411d0818$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.maxwell.syr.edu!c03.atl99!news.usenetserver.com!news02.tsnz.net!newsfeed01.tsnz.net!news.xtra.co.nz!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

References: <40628346$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: fcd2b,d383246b3c12b33
X-Google-Attributes: gidfcd2b,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Nick Rambarransingh" <NRambarransingh@Rogers.com>
Sender: "Nick Rambarransingh" <NRambarransingh@Rogers.com>
Reply-To: "Nick Rambarransingh" <NRambarransingh@Rogers.com>
Subject: Re: How best can I do this?
Newsgroups: borland.public.cppbuilder.database.multi-tier
X-User-Info: 131.137.245.197     
X-Forwarded-For: unknown, unknown
References:  <40628346$1@newsgroups.borland.com>
NNTP-Posting-Host: 207.105.83.66
Message-ID: <411d0818$1@newsgroups.borland.com>
Date: 13 Aug 2004 11:27:36 -0700
X-Trace: newsgroups.borland.com 1092421656 207.105.83.66 (13 Aug 2004 11:27:36 -0700)
Lines: 29
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.maxwell.syr.edu!c03.atl99!news.usenetserver.com!news02.tsnz.net!newsfeed01.tsnz.net!news.xtra.co.nz!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Reply to Parent Message