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



Reply via email to