Ferry Check-out
http://personal.vsnl.com/sukesh_hoogan/csql.html#Nbr03 Regards Sukesh Hoogan Ferry <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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 > >
