Row number in a form

Business Central/NAV Developers Forum
1

Yo! A user wants a row number in his form to see how many rows he has enterd/added. (Like Excel?) Then he can quickly check if he has enterd the form correctly compered to his concept. Is there a property? We’re on SQL 3.70 /K

2

Include a new textbox in the lower part of your form, a new record type variable of that same table, and in the OnAfterGetCurrRecord trigger you apply the respective filters (if necessary) and do a COUNT on that record variable. Saludos Nils

3

quote:

Include a new textbox in the lower part of your form, a new record type variable of that same table, and in the OnAfterGetCurrRecord trigger you apply the respective filters (if necessary) and do a COUNT on that record variable. Saludos Nils
Originally posted by nilsm - 2006 May 19 : 17:13:41

Or if you want ot do it the easy way; … add a TextBox control to the form, and add the source expression COUNT. [^]

4

Thanx Nils + David! /K

5

I did read somewhere that you should use the COUNTAPPROX, as it is Faster! [:D]

6

quote:

I did read somewhere that you should use the COUNTAPPROX, as it is Faster! [:D]
Originally posted by David Cox - 2006 May 23 : 08:43:24

I may be wrong, and I will deffer to one of our local SQL experts on this, but … AFAIK this only makes a difference on SQL. But in this case it wouldn’t be appropriate for two reasons. One is that the user in this case needs to know exactly how many records they have created, so an approx would not help. Second, (and I may be wrong), count approx is only fast ecause it uses the SQL count of total number of records, and if there are filters, then it falls back to count anyway.