Re: Children class loop with SQL

[Bill McCormick]

Select * from UserDate.InvoiceChildren where InvoiceParent = ?

then pass the id of the parent to the Execute() statement.

Ferry wrote:

hello i have a Parent and Children classes.
But how can i make a loop with SQL trough the children class?

For the parent class is it easy

     S qSQL="SELECT * FROM  UserData.Invoice ORDER BY HDate"
     S mr=##class(%ResultSet).%New()
     D mr.Prepare(qSQL)
     D mr.Execute()
     while mr.Next() {
     W mr.GetData(3)_"<br>"

    S ID=mr.GetData(1)
    // Write children with ID

    }
    D mr.Close()

But it don't work for the children class