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

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.

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.

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

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.