Debugger shows record already exists error on .COUNT

EvR

Hi all,

My debugger is throwing a record already exists exception, but in a very strange point in the code.

(Function in table)
MyRecWithFilters.SETRANGE("Filter Field",TRUE);
"My Field" := MyRecWithFilters.COUNT > 0;

The COUNT line crashes with a record already exists error.
Is this just a bug in the debugger that is leading me on? If so, any suggestions on how to pinpoint the real error location?

Belias

It is most probably due to the bulk insert feature: you insert somewhere else in the code, but sql doesn't actually start to insert records until a commit or a table read (COUNT is one of those reads).
EDIT: the "bad insert" (with the same PK) probably lies in the "(Function in table)"

Belias

It is most probably due to the bulk insert feature: you insert somewhere else in the code, but sql doesn't actually start to insert records until a commit or a table read (COUNT is one of those reads).
EDIT: the "bad insert" (with the same PK) probably lies in the "(Function in table)"

EvR

Thanks. Found it (outside the function somewhere).