Hi,
Is there a quick way to get the number of records added to a dataset after performing FILL()?
My data source is a query, and I thought of getting NUM-RESULTS after FILL(), but that returns ?, probably because the query is already closed (IS-OPEN returns false).
I could write some routine counting the current number of records and the number after FILL() (FILL-MODE is APPEND), but something built-in, and fast, has my preference off course...
Edit: What I actually need in my specific case is to know if the FILL() operation added any records or not... So perhaps I'm already too much in solution-mode posing the above question...
The dataset events were a good hint Peter. For my simple requirement of knowing if any records were added (FILL-MODE = APPEND), I should be able to use a flag in the AFTER-ROW-FILL to know if anything was added...
I'd try to avoid AFTER-ROW-FILL. It has negative impact on the performance. I'm, pretty sure that counting records in the TT before and after will be faster - if that's the only option.
Hi Mike,
Yes, I've heard you say that before, but we don't have that experience here (an AFTER-ROW-FILL is already in place, so adding that flag there won't make the difference either).