Who generates SQL query in NAV?

Phenno

Hello all,

Maybe the subject is little bit wrong but here is what I would like to know.

I have development and production environment that are pretty much similar. I'm running navision 4 sp3 and with client monitor check in one specific report. For the one specific command (that is repeated for several times) on development I see the same query every time, select top 1 null. But, on production, first three times it executes select top 500 *, and the rest is select top 1 null.

Based on what Navision could decide to issue different commands for the same navision command, even in the same running (production)?

Phenno

I have to correct my self, there was a difference in build versions, so in those updates SQL query for findset command has been changed.