AOT query - what to use to loop over many records(While function)?

(0) Share

Report

Posted on by ShawnDEV

678

Hi,

We do have two ways of creating a query:

1) Query by using AOT (visualization)

2) Query by using X++

I know that we can use 'while' select statement to loop over many records in query using X++

But then is there a way that we can achieve the effect of 'while' function if we have to create a query using AOT..? Or do we ALWAYS have to create query in x++ if we have to loop over many records ?

Thank you.

*This post is locked for comments

I have the same question (0)

All responses (2)

Answers (2)

Verified answer

Sergei Minozhenko 23,093 on at

Like (0)

Report
Hi ShawnDEV,

Do you want to use the query created in AOT in x ?

If yes, you can do it with QueryRun object

Query query = new query(queryStr(MyQuery)); QueryRun = queryRun = new QueryRun(query); while (queryRun.next()) { MyTable myTable = queryRun.get(tableNum(MyTable)); }

Was this reply helpful? Yes No
Verified answer

Martin Dráb 237,805 Most Valuable Professional on at

Like (0)

Report

I'm lockling this thread, because it duplicates what's already discussed in ShawnDEV's other thread.

Was this reply helpful? Yes No