Microsoft KB Archive/176932

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

Article ID: 176932

Article Last Modified on 9/24/2001

-

APPLIES TO


 * Microsoft FrontPage 97 Standard Edition

-



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.

Additional query words: 97 IDC MaxRecords wizard fpodbc

Keywords: kbhowto KB176932

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.