Skip to Content
Former Member
Apr 04, 2016 at 11:03 PM

999 Error Only the cancel command is allowed when rows are pending


I have started experiencing a really strange issue lately. Sometimes when I retrieve into a tabular or grid datawindow and I have another window open I get this error. I optimized the pbls and did a full rebuild but it didn't resolve it.

However, I found that if I get the row count in the datawindow constructor event and set the height to that count * the detail row height it retrieves correctly. I already know for a certainty that no retrieval is taking place. This is PB Classic 12.5.2 build 5602 running on windows 7 Enterprise Service Pack 1.

Has anyone else experienced this behavior or know if this is a known bug? What makes this really interesting is that we haven't updated PB in years. This is a legacy system that was been around for about 12-13 years and no changes have been made that would cause this to occur.

Any help/ideas would be greatly appreciated.