IWSIDOCollection GetNumEntries returns entries that don't exist

I'm stumped on a very simple issue on a form script. I have a form script that declares a IWSIDOCollection variable and assigns the primary IDO Collection to it as its value. I have some business logic that I want to apply that is basically if IWSIDOCollection.GetNumEntries() > 0 then do stuff.

The issue I'm running into is that GetNumEntries() is showing a count of 2 when there aren't any records in the collection at all. I've seen this before, but I don't remember what I did to fix.

This is throwing off iteration counts as well. i.e., For i = 0 To oCache.GetNumEntries() - 1.

What am I missing?

Find more posts tagged with

Accepted answers

All comments

Legacy Contributor

To test/verify this issue, in the same Sub, I queried the IDO via LoadCollectionRequestData call and works as expected.

tdickens

I think you need to check if an object property equals String.Empty. And skip any rows that are empty.

Here's what I've done. This screenshot is not for the primary collection. But you can get the idea.

Legacy Contributor

Yup - this is very similar structure what I'm trying to accomplish. Using your code as an example, I want to say that if var cnt = 0 do "this". If var cnt > 0 then do "that" I'd rather not iterate the collection to weed out any "blank" records if at all possible.

Maybe I'm having a brain freeze moment due to the holidays and misusing the GetNumEntries method.

tdickens

Please let me know if you figure out a better way. That's all I've been able to come up with.

I "think" that the extra occurrence in the collection comes from the Collection settings. I set the Standard Operation settings to false. I think that keeps the extra occurrence from happening. But I may be wrong on that.

antonio-caria

If For i = oCache.GetNumEntries() returns 2

then For i = 0 To oCache.GetNumEntries() - 1 will run's 2 times (i=0 and i=1).

kazuyuki-mochizuki

I think if IDO Collection new is enabled its -2 if its not then -1. Maybe you can check if IDO.NewEnabled = true via code and decide whether to use -2 or -1?

Legacy Contributor

Didn't know this. I'll try it out.

Copyright © 2025 Infor. All rights reserved.