Debugger shows record already exists error on .COUNT

EvR · 2016-01-27

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 · 2016-01-27

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 · 2016-01-27

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 · 2016-01-27

Thanks. Found it (outside the function somewhere).

Debugger shows record already exists error on .COUNT

Best Answer

Answers

Categories