🚀 go-pugleaf

>I have a form with 2 table in relation father-child 1:N;
>I must in the same table filter the rowset for same fields of the father
>table and one field of the child table and the  query do need to be live
for
>modified it.
>I input the filter option in same entryfield object and then i apply the
>form.query1.rowset.filter=.... value of entryfiled
>
>How i can do for filter also a field of the child table?? Can i do the
>CanGetRow() function?? How i can use it??

You must apply the constraint using an independent instance of the child
query, e.g.:

this.ChildConstraint = new query()
with (this.ChildConstraint )
   sql = ........
endwith

with (this.ChildConstraint.rowset)
   indexName = "TAGNAME"
endif

function ConstraintQuery_OnOpen
   this.parent.ParentQuery.ConstraintRowset = this

function ParentRowset_CanGetRow
   return this.ConstraintRowset.findKey( <expression> )
____
Bowen Moursund (dBASE, Inc.)
bowen at nerds dot com