Microsoft KB Archive/100996

From BetaArchive Wiki

PRB: "Line Too Long" Message in RQBE

ID: Q100996

2.50 2.50a 3.00 | 2.00 2.50 2.50a

WINDOWS         | MS-DOS
  kbprb

The information in this article applies to:

  • Microsoft Visual FoxPro for Windows, version 3.0
  • Microsoft FoxPro for Windows, versions 2.5 and 2.5a
  • Microsoft FoxPro for MS-DOS, versions 2.0, 2.5, and 2.5a

SYMPTOMS

In RQBE, the following error message occurs:

   Line too long

CAUSE

Running an RQBE session on a table with a large number of fields will produce error 18, "Line too long," every time the Do Query button is chosen after a field was moved up in the Output Fields box. This problem occurs because the resulting SELECT statement would exceed the maximum command-line length, which is 2048 characters.

Before the order of the fields changed, RQBE generated a SQL statement of SELECT * FROM <table_name>; however, after the order of fields changed, it had to create a SQL statement similar to the following:

   SELECT <fld1>, <fld2>,....<fldn> FROM <table_name>

RESOLUTION

If the field order is not changed in the Output Fields box, the error does not occur. Therefore, to avoid the problem, do not change the order of the fields.

Additional reference words: FoxDos FoxWin VFoxWin 2.50 2.50a RQBE errmsg err msg

KBCategory:   kbprb

KBSubcategory: FxtoolRqbe

Keywords          : kberrmsg FxtoolRqbe 
Version           : 2.50 2.50a 3.00 | 2.00 2.50 2.50
Platform          : MS-DOS WINDOWS

Last Reviewed: May 22, 1998
© 1999 Microsoft Corporation. All rights reserved. Terms of Use.