How can I turn a while select into a Query?

(0) Share

Report

Posted on by Pavel Ioana

102

How can I turn the code below into Query using only code and without using Query from AOT?

while select custInvoiceJour
    where ((invoiceAccount && custInvoiceJour.InvoiceAccount == invoiceAccount) || !invoiceAccount)
       && custInvoiceJour.InvoiceDate >= fromDate
       && custInvoiceJour.InvoiceDate <= toDate
       && ((salesId && custInvoiceJour.SalesId==salesId) || !salesId)
       && ((salesTaker && custInvoiceJour.WorkerSalesTaker==salesTaker) || !salesTaker)
    join custTable
        where custTable.AccountNum == custInvoiceJour.InvoiceAccount
    join dirPartyTable
        where custTable.Party == dirPartyTable.RecId
    join salesTable
        where salesTable.SalesId == custInvoiceJour.SalesId
        && ((salesResponsible && salesTable.WorkerSalesResponsible==salesResponsible) || !salesResponsible)

All responses (2)

Answers (0)

Ferhat.S 231 on at

Like (0)

Report

RE: How can I turn a while select into a Query?

You might wanna be have a look at this link: learn.microsoft.com/.../how-to-create-queries-by-using-x
Martin Dráb 230,188 Most Valuable Professional on at

Like (0)

Report

RE: How can I turn a while select into a Query?

You'll need to write the code. Do you have any particular problem with it?