Strange problem of generating sequence number

HCL Domino Domino Forum
1

Hi,I want to use following formula to generate sequence no:

x := @Count(@DbColumn(“”:“ReCache”;server:“DTM.nsf”;“DTMView”;2));

but it is very strange that for the 1st 2 times I always get same sequence numbver: 000001. and from the 3rd time, I can get correct no: 000003.

Does anyone know the reason?

2

Subject: strange problem of generating sequence number

@Count returns 1 when there is no document or 1 document in the view. This may be the reason.