Microsoft KB Archive/191234

= BUG: ESQL: Error -19104 If Column, Table, or Alias Name Starts with CURRENT =

Article ID: 191234

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q191234



BUG #: 17729 (SQLBUG_65)



SYMPTOMS
If the WHERE clause of a SELECT statement is followed by a column name, a table name, or an alias that starts with "CURRENT", the precompilation will fail with the following error:

Error code -19104

Incorrect SQL statement syntax.

This occurs only when using a SELECT statement (whether it is a SELECT INTO or part of a DECLARE CURSOR statement). It does not occur when using a DELETE or an UPDATE statement.



WORKAROUND
If an alias name starts with CURRENT, change the alias name so that it does not begin with CURRENT.

If a table name or column name itself starts with CURRENT, use an alias. (Do not use an alias that begins with CURRENT.)

Starting with SQL Server 7.0, you can use delimited identifiers: select * from pubs [current] where [current].au_lname = 'White'

create table [current] (col1 int)

create table mytable([current] int)



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Additional query words: ESQL ESQL/C ESQL-C

Keywords: kbbug kbpending KB191234

-

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

© Microsoft Corporation. All rights reserved.