Using Filters/Find Routines HELP

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

Article #5855

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

#5855

From: John Tresidder
Date: Fri, 02 Feb 2001 19:29

25 lines
1988 bytes

Hi
  I'm not sure if this is a bug because I'm new at using databases.
But.

  I set up some tables in a Master/Detail relationship as per 
instructions in many books and they work fine for "filtering" amongst 
these tables when using some dbgrids set up this way.
Yet if I specify the Master/Detail relationship for the tables at design 
time the functions such as
Filter, FindPrior, FindLast etc seem to not work on the detail table.
I've gotten around this by setting the Master/Detail relationships only 
when I need them and Removing them when I need to use those routines.
In the Object Explorer the specific Properties that seem to have an 
effect are for the TTable class are :  MasterSource and MasterFields (on 
the Detail Table)

Please note all of the referential integrity has been confirmed, and the 
correct master fields have been specified.

Any Help / Explaination would be appriciated.

Thanks
          Richard Tresidder
          rtresidd@tresar-electronics.com.au 
<mailto:rtresidd@tresar-electronics.com.au>

Technical Details

Message-ID: <3A7B0A94.8070004@tresar-electronics.com.au>

Path:

arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!news.tele.dk!194.213.69.151!news.algonet.se!algonet!newsfeed1.uni2.dk!newssuck.uni2.dk!bornews.borland.com!dnews!202.168.101.253

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,1185c338f594d182,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-02-02 11:32:20 PST
Message-ID: <3A7B0A94.8070004@tresar-electronics.com.au>
Date: Sat, 03 Feb 2001 03:29:24 +0800
From: John Tresidder <jtresidd@tresar-electronics.com.au>
User-Agent: Mozilla/5.0 (Windows; U; Win98; en-US; m18) Gecko/20001108 Netscape6/6.0
X-Accept-Language: en,pdf
MIME-Version: 1.0
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Using Filters/Find Routines HELP
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 202.168.101.253
X-Trace: 2 Feb 2001 11:25:42 -0800, 202.168.101.253
Lines: 26
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!news.tele.dk!194.213.69.151!news.algonet.se!algonet!newsfeed1.uni2.dk!newssuck.uni2.dk!bornews.borland.com!dnews!202.168.101.253