Insert Bug with COUNTAPPROX

SonGoten13

Hi,

Setup: NAV 6.0 R2 (6.00.33639), Classic Client, SQL Server 2008

Following Code given:

IF RecordBuffer.FINDLAST THEN;
RecordBuffer."Entry No." := RecordBuffer."Entry No." + 1;
RecordBuffer.INSERT;
IF CONFIRM('kill the insert',TRUE) THEN
  Count := RecordBuffer.COUNTAPPROX;

The COUNTAPPROX "kills" the insert again on a normal user(it doesn't matter which table). If i give the User "sysadmin" rights on the SQL side, the insert gets commited.

I searched the forum and found some info that there is a bug with COUNTAPPROX, but always just with the NAV 4 Version, and no solution.

Can anyone confirm this behaviour and/or provide some advice?
thanks

Marije_Brummel

COUNTAPPROX is based on SQL Server statistics. Maybe normal users do not have access to that data on SQL Server?

It is also extremely unreliable and therefore hardly never used.