Re: RowFilters with related tables

Tech-Archive recommends: Fix windows errors by optimizing your registry

Pete,

In my opinion can you not create this using a filter in SQL and as well will
you not be able to do that in a dataset. Because there is nothing to filter,
it is matching.

The same as in SQL you can use the getchildrows to make a seperate table.

I hope this helps,

Cor



"Pete Davis" <pdavis68@[nospam]hotmail.com> schreef in bericht
news:4NidnfvNa5nsianeRVn-tw@xxxxxxxxxxxxxxx
> "Cor Ligthert [MVP]" <notmyfirstname@xxxxxxxxx> wrote in message
> news:O1uMYxEwFHA.708@xxxxxxxxxxxxxxxxxxxxxxx
>> Pete,
>>
>> Reading your text I am in doubt if the select can help you.
>>
>> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdatadatatableclassselecttopic.asp
>>
>> Otherwise I would go for the getchildrows and see if that is zero.
>> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdatadatarowclassgetchildrowstopic.asp
>>
>> I hope this helps something
>>
>> Cor
>
> Thanks, but that's not going to do it. I guess what I neglected to mention
> is this has to be done as a RowFilter since it's a DataViewManager which
> is bound to a grid control. I want the grid to only show the parent rows
> for parents that have children and the children which meet the row filter
> criteria.
>
> I know, this is probably some where in the land of obscurity. I mean, just
> figuring out how to bind a grid to a DataViewManager and apply filters
> took a bit of digging. MS didn't really go out of their way to document
> this stuff.
>
> Pete
>


.

Relevant Pages

  • Re: Equivalent of Get Next Extended to retrieve only unique keys?
    ... Do you know of any good resources for the ins & outs of accessing a btrieve database through SQL to supplement Pervasive's documentation? ... sort by various columns of data and to also filter on the columns. ... doesn't contain dozens of entries for the same patient. ... level of duplication is low, then perhaps you can do a regular GNE ...
    (comp.databases.btrieve)
  • Re: Searching
    ... MVP Access ... It would be best to build a filter string for the form ... click on the builder button for the RowSource property of your listbox and build the SQL -- use some criteria too. ... Dim mFilter As String ...
    (microsoft.public.access.queries)
  • Re: Mail Merge Using Date Filters With SQL Data Source
    ... monitoring the SQL Word sends to the server and yes it is not correct SQL ... > an ODBC DSN on each machine that needs to access this data source. ... > connect via SQL Query (in Word 2002/2003 the option is on the Tools menu ... >> We have a problem using the filter data source option when mail merging ...
    (microsoft.public.word.mailmerge.fields)
  • Re: MailMerge only pulls first record from SQL table when filtered
    ... When the connection to the SQL server is direct, I think most people would expect Word to send a SELECT statement with a WHERE clause to SQL Server, SQL Server to assemble the result set, and return it to Word, in the usual way. ... I wonder if it is getting a complete result set, then using something like ADO to filter the results and getting it wrong. ... tell us the data type of the InvoiceNumber column in SQL/Access ... would simply pull the first record, no matter what the InvoiceNumber was. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Translating some code from .NET to VB6
    ... SQL statement that includes the filter, then test the number of rows that are brought ... After you correctly open the query, you can use the Recordcount property to determine how ... How can I do it on vb6? ...
    (microsoft.public.vb.general.discussion)