FP97: Maximum Number of Data Rows Fetched Incorrect in IDC Query (176932)

The information in this article applies to:

Microsoft FrontPage 97 for Windows with Bonus Pack

This article was previously published under Q176932

SYMPTOMS

The results of an IDC query may be incorrect when you run a query on the Microsoft Personal Web Server (MSPWS) for Microsoft Windows 95 even though you selected the "Maximum number of rows fetched" option and specified a limit to the number of rows to be returned.

To locate the "Maximum number of rows fetched" option, double-click the .idc file, click Advanced Options in the Internet Database Connector Wizard, and then click the Limits tab.

CAUSE

This problem occurs because the IDC Wizard places the MaxRecords entry after the SQL string rather than before the SQL string in the IDC file it creates. Therefore, since the MSPWS evaluates the file from top to bottom in only one pass, the SQL query is executed before the MaxRecords statement is evaluated.

RESOLUTION

Open the .idc file in a text editor such as Notepad, and move the MaxRecords entry so that it appears above the SQL statement.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

This problem was corrected in FrontPage 98.

Modification Type:	Major	Last Reviewed:	9/24/2001
Keywords:	kbhowto KB176932