Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Why does the IDP sometimes only display one case when I set “Preview the first n cases” to some number greater than one?

April 26, 2017Case display greater IDP

0

Posted

Why does the IDP sometimes only display one case when I set “Preview the first n cases” to some number greater than one?

1 Answer

0

Posted

When using a forward-only cursor, the IDP does not advance the Recordset beyond the first case (row) because then those first n rows would be lost and when an Analysis requested that data, the query would have to be executed again. “Preview the first n cases” only applies when using a static cursor.