BUG: Error -19104 If Column/Table/Alias Name Starts with CURRENT

ID: Q191234

The information in this article applies to:

Microsoft Embedded SQL for C Programmer's Toolkit version 6.5

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

Alias Name

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

Table or Column Name

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

STATUS

Microsoft has confirmed this to be a problem in Microsoft Embedded SQL for C Programmer's Toolkit version 6.5.

Additional query words: ESQL ESQL/C ESQL-C

Keywords          : SSrvESQL_C kbbug6.50 
Version           : WINNT:6.5
Platform          : winnt
Issue type        : kbbug
Solution Type     : kbpending

Last Reviewed: August 13, 1998