Total number of rows when executing script

[a_yershov]

Hello, everybody!

Sorry for a simple question, I'm sure it has already been discussed before, but I can't find that.

When reloading data (executing script), is there an option to show total number of rows in the table being loaded? That is, to see not only the current row number, but to estimate its relative position and, hence, expected time left. Something like "2568000 of 6800000".

I suppose the answer is "no", but was worth trying anyway.

Many thanks in advance!

[dplr-rn · Accepted solution]

i dont believe  so.

you could load just the count into a temporary table and display it while loading as a reference point. but relative count is not possible afik

[a_yershov]

Thought so. Thanks anyway, dilipranjith!

[Brett_Bleess]

The only thing that might get you in the ballpark would be using RecNo() or RowNo() functions, but the trick would be getting those values to pop out etc...  Just wanted to toss this out in case it prompts something for someone else that might work.  

I also forgot to point out the Script Debugger in the Script Editor, not exactly sure what your use case is, but having the reload dialog appear I believe shows the record counts as things are loading if I recall correctly.

The Script Execution Progress dialog, but that will only be visible if using the Desktop Client, when using Publisher, there is no way to see that, and the Task log does not show the specifics, just Loading...

Cheers,
Brett