Microsoft KB Archive/170304

= BUG: ESQL-C Precompiler Generates Syntax Errors on Cursors =

PSS ID Number: 170304

Article Last Modified on 12/2/2002

-

The information in this article applies to:


 * Microsoft Embedded SQL for C Programmer's Toolkit

-



This article was previously published under Q170304



SYMPTOMS
BUG #: 15939 (NT: 6.50)

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; An INSENSITIVE cursor has a fixed membership (defined at open) and does not allow updates. EXEC SQL SET SCROLLOPTION KEYSET;

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

Additional query words: 6.50.204

Keywords: kbBug kbProgramming KB170304

Technology: kbAudDeveloper kbSQLEmCPTKSearch kbSQLServSearch

-

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

© Microsoft Corporation. All rights reserved.