elton
12/15/2005 7:33:00 AM
Thank you so much, Daniel Grau.
"Daniel Grau" wrote:
> hi elton,
>
> I guess you're looking for something like this:
>
> while(qrCustInvoiceJour.next())
> {
> if(qrCustInvoiceJour.changed(tableNum(CustInvoiceJour)))
> {
> Jour = qrCustInvoiceJour.get(tableNum(CustInvoiceJour));
> element.send(Jour);
> }
>
> if(qrCustInvoiceJour.changed(tableNum(CustInvoiceTrans)))
> {
> Trans = qrCustInvoiceJour.get(tableNum(CustInvoiceTrans));
> element.send(Trans);
> }
>
> }
>
> hope this helps...
> regards
> daniel
>
> "elton" wrote:
>
> > querybuildDatasource qbds1, qbds2;
> > ;
> > qCustInvoiceJour = new query();
> > qbds1 = qCustInvoiceJour.addDataSource(tablenum(CustInvoiceJour));
> >
> >
> > qbds2= qbds1.addDataSource(tablenum(CustInvoiceTrans));
> >
> >
> > qbds2.addRange(fieldnum(CustInvoiceTrans,InvoiceDate)).value(queryrange(this.fromDate(),this.toDate()));
> > qbds2.relations(true);
> >
> > qrCustInvoiceJour =new queryrun(qCustInvoiceJour);
> >
> > while(qrCustInvoiceJour.next())
> > {
> > Jour = qrCustinvoiceJour.get(tablenum(CustInvoiceJour));
> > element.send(Jour);
> > â?¦
> > â?¦
> > }
> >
> > Result of Qbds1 when I debug like this:
> > SELECT * FROM CustInvoiceJour JOIN * FROM CustInvoiceTrans WHERE
> > CustInvoiceJour.SalesId = CustInvoiceTrans.SalesId AND
> > CustInvoiceJour.InvoiceId = CustInvoiceTrans.InvoiceId AND
> > CustInvoiceJour.InvoiceDate = CustInvoiceTrans.InvoiceDate AND
> > CustInvoiceJour.numberSequenceGroup = CustInvoiceTrans.numberSequenceGroup
> > AND ((InvoiceDate>=7/1/2005 AND InvoiceDate<=11/23/2005))
> >
> > And Qbds2:
> > SELECT * FROM CustInvoiceTrans WHERE CustInvoiceJour.SalesId =
> > CustInvoiceTrans.SalesId AND CustInvoiceJour.InvoiceId =
> > CustInvoiceTrans.InvoiceId AND CustInvoiceJour.InvoiceDate =
> > CustInvoiceTrans.InvoiceDate AND CustInvoiceJour.numberSequenceGroup =
> > CustInvoiceTrans.numberSequenceGroup AND ((InvoiceDate>=7/1/2005 AND
> > InvoiceDate<=11/23/2005))
> >
> > Can I get CustInvoiceTrans from querybuildDatasource Qbds2 or Qbds1 ?if
> > possible,please help me how to get. Thanks
> >