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

ID: q176932

The information in this article applies to:

SYMPTOMS

The results of an IDC query may be incorrect when you run a query on the Microsoft Personal Web Server (MSPWS) for 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.

Microsoft Technical Support will not resolve problems produced by editing the HTML that FrontPage generates. For more information about writing HTML, please see the following Microsoft Web site: 

   http://www.microsoft.com/workshop/author/newhtml/default.htm.
NOTE: Because the Microsoft Web site is constantly updated, the site address may change without notice. If this occurs, link to the Microsoft home page at the following address: 

   http://www.microsoft.com

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem was corrected in Microsoft FrontPage 98.

Additional query words: 97 IDC MaxRecords wizard fpodbc 

Keywords          : kbdta
Version           : WINDOWS:97
Platform          : WINDOWS
Hardware          : x86
Issue type        : kbhowto

Last Reviewed: July 1, 1999