PRB: Connectivity Kit Produces Error 252 with No Error Message

ID: Q116272

2.50 2.50a 2.50b 2.60 | 2.50

WINDOWS               | MS-DOS
  kbprb

The information in this article applies to:

SYMPTOMS

When you are executing a DBExec() function with a SELECT statement that returns approximately 40 or more fields, an error of 252 is returned from the DBError() function with a null error message.

CAUSE

The error occurs because the Connectivity Kit is generating an Xbase command to create a cursor or table in FoxPro with a large number of fields, and the command that is generated is exceeding the maximum length of a compiled line in FoxPro (1024 bytes). The number of fields required to cause the error varies based on the length of the column names. In general, however, the error is likely to occur when 20 or more fields are included in the SQL Select command.

RESOLUTION

There are several ways to work around the problem:

Additional reference words: FoxDos FoxWin 2.50 2.50a 2.50b 2.60 CK 252 errmsg err msg ODBC
KBCategory:   kbprb
KBSubcategory: FxtoolCk
Keywords          : kberrmsg FxtoolCk 
Version           : 2.50 2.50a 2.50b 2.60 | 2.50
Platform          : MS-DOS WINDOWS

Last Reviewed: May 22, 1998