BUG: ESQL-C Precompiler Generates Syntax Errors on Cursors

ID: Q170304

The information in this article applies to:

• Microsoft Embedded SQL for C Programmer's Toolkit, version 6.50

SYMPTOMS

When attempting to define an ESQL-C cursor using the SCROLL or INSENSITIVE keywords, the precompiler generates a syntax error.

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server Embedded SQL for C Programmer's Toolkit version 6.5. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

A SCROLL cursor allows first, last, and backwards fetch operations.

   EXEC SQL SET CURSORTYPE CUR_STANDARD;
   EXEC SQL SET SCROLLOPTION KEYSET;

   EXEC SQL DECLARE curAuthor CURSOR FOR SELECT au_fname from authors;

   EXEC SQL SET SCROLLOPTION KEYSET;

   EXEC SQL DECLARE curAuthor CURSOR FOR SELECT au_fname from authors
   FOR READ ONLY;

Keywords          : kbprg SSrvESQL_C SSrvProg kbbug6.50 
Version           : 6.5
Platform          : WINDOWS
Issue type        : kbbug
Solution Type     : kbpending

Last Reviewed: July 10, 1997