|
Home > Archive > Programming with dBASE > February 2006 > Constraining the parent row
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Constraining the parent row
|
|
|
| Hiall,
Is the only way, in a dmd, to constrain the parent row, to all those rows
that have valid child rows, by using a cangetrow event.
I need to only display a parent row that has valid child related rows.
Traditionally I've done that with a cangetrow. But this is rather slow.
I don't want to use a sql statement that produces a temp table, as I need
the indices associated with the parent and child rows. A temp table will
indeed give me the results, less the indices
Thanks
Robert
| |
| Mark Wood 2006-02-06, 11:23 am |
|
"rb" <me@u.com> wrote in message news:H3578Z0JGHA.1104@news-server...
> Hiall,
>
> Is the only way, in a dmd, to constrain the parent row, to all those rows
> that have valid child rows, by using a cangetrow event.
> I need to only display a parent row that has valid child related rows.
> Traditionally I've done that with a cangetrow. But this is rather slow.
> I don't want to use a sql statement that produces a temp table, as I need
> the indices associated with the parent and child rows. A temp table will
> indeed give me the results, less the indices
>
> Thanks
> Robert
>
>
You could try creating a calculated field of the master rowset that
evaluated to true/false depending on its child rowsets, then use the filter
command on the master rowset using the calculated field in the expression.
I think that would be worth a go
Mark
| |
| Robert Bravery 2006-02-06, 8:24 pm |
| MMM might be worth looking at.
What I'm looking for here is the fastest method
Thanks
Robert
"Mark Wood" < mark@pioneeroiltools
.com.nospam> wrote in message
news:sVZw06zKGHA.1104@news-server...
>
> "rb" <me@u.com> wrote in message news:H3578Z0JGHA.1104@news-server...
rows[color=darkred]
need[color=darkred]
>
> You could try creating a calculated field of the master rowset that
> evaluated to true/false depending on its child rowsets, then use the
filter
> command on the master rowset using the calculated field in the expression.
>
> I think that would be worth a go
>
> Mark
>
>
|
|
|
|
|