Using Filters/Find Routines HELP

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

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by John Tresidder Fri, 02 Feb 2001 19:29

#5855

Author: 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>

Re: Using Filters/Find Routines HELP

#5774

Author: John Tresidder
Date: Fri, 09 Feb 2001 17:58

34 lines
2313 bytes

Why has know one replied to this mesage yet??????
    I'm still curious, and have waited a week,
Whats wrong with the question you guys from TeamB????
I've seen you respond to more resent messages.
No bad intentions there, I'm just lost for answers.....


Richard Tresidder wrote:

> 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>

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads