Microsoft KB Archive/150375

{|
 * width="100%"|

XL5: Syntax Errors Using Array Fields in MSQuery

 * }

-

The information in this article applies to:


 * Microsoft Excel for Windows, versions 5.0, 5.0c

-

WARNING: The information in this article has not been confirmed or tested by Microsoft. Some or all of the information in this article has been taken from unconfirmed customer reports. ANY USE BY YOU OF THE INFORMATION PROVIDED IN THIS ARTICLE IS AT YOUR OWN RISK. Microsoft provides this information "as is" without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose.

SYMPTOMS
When running a query against a Progress database with an OpenLink driver (version 1.1010825) in Microsoft Query version 1.0, you may receive the following error message

No reference to array fields without subscript in embedded SQL (1763)

followed by the following error message:

Syntax error or access

CAUSE
The driver is returning this error message because of a syntax error in the SQL statement that the database receives.

WORKAROUND
WARNING: Microsoft has not tested the workaround and therefore cannot guarantee its results.

Place a backslash in front of any bracket that contains an array field. For example, the following statement would cause an error

  SELECT FieldName[1] FROM TableName where the [1] indicates an element in an array composed of fields. The following line of code works:

  SELECT FieldName\[1] FROM TableName Additional query words:

Keywords : xlquery

Version : WINDOWS:5.0,5.0c

Platform : WINDOWS

Issue type :

Technology :