Finance | Project Operations, Human Resources, ...

Unanswered

QueryRun.next() only looping once, even though SysQueryRun::countLoops(queryRun) shows the total number of loops = 3

(2) Share

Report

Posted on by apndt3

I am currently trying to loop through the data being pulled by the QueryRun object I made. The query generated by the filters/ranges I set does pull the correct rows when I translated the query to SQL. I also used SysQueryRun::countLoops(queryRun) to see how many rows were in the queryRun obj, and it said 3 (which is how many I excepted and how many where returned by the SQL query).

However, when I debug and enter the while(queryRun.next()) loop, it only loops once before queryRun.next() returns false. Therefore, only one row is processed and returned. Is there another way to grab the rows that are tied to the queryRun obj?

I have the same question (0)

All responses (7)

Answers (0)

Blue Wang on at

Like (1)

Report
HI Apndt3,

Is it easy to share your code?

While(queryRun.Next()) { common = queryRun.get(tableId); }

You can try to transform the code, although they mean the same.

if(queryRun.next()) { common = queryRun.get(tableId); } while(common) { ...; next common; }

Was this reply helpful? Yes No

apndt3 on at

Like (0)

Report

Thank you for your response!

The original code I had was:

while (queryRun.next())

{

table1 = queryRun.get(tableId1); //main salesTable

table2 = queryRun.get(tableId2);

table3 = queryRun.get(tableId3);

salesLine = salesLine::findId(table3);

...

}

I did try what you suggested a few days ago, but get this error :

Stack trace: Cannot call the NEXT command at this point. Either: (a) the buffer was initiated on the server, (b) SELECT was never called, (c) SELECT was called but no more rows exists, or (d) data was assigned using the data() method.

I tried just using one table and calling the other queryRun.gets in the while loop, but <next table1> returned false by the second iteration.

Was this reply helpful? Yes No

Sergei Minozhenko 23,093 on at

Like (1)

Report

Hi apndt3,

You mentioned SysQueryRun::countLoops method. Is class name SysQueryRun or SysQuery? If you remove this call, does while(queryRun.next()) loop work correctly?

Was this reply helpful? Yes No
apndt3 on at

Like (0)

Report

Unfortunately it doesn't. I had added the SysQueryRun call as an attempt to see whether the queryRun object was matching up to the SQL statement produced and actually holding more than a single line. The issue with the loop had been happening prior to adding the call

Was this reply helpful? Yes No
Sergei Minozhenko 23,093 on at

Like (0)

Report

Hi apndt3,

Could you, please, share you query object is created (query structure)?

Was this reply helpful? Yes No
apndt3 on at

Like (1)

Report

Thank you so much for your responses, but I just got it working! Thanks for you time I really appreciate it

Was this reply helpful? Yes No
RT-17121508-0 6 on at

Like (1)

Report

@apndt3 : How did you fix this issue ? I am facing the same. Many thanks in advance!!

Was this reply helpful? Yes No

Join the conversation

Community site session details

QueryRun.next() only looping once, even though SysQueryRun::countLoops(queryRun) shows the total number of loops = 3

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

QueryRun.next() only looping once, even though SysQueryRun::countLoops(queryRun) shows the total number of loops = 3

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates