Microsoft KB Archive/170304

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 15:35, 18 July 2020 by 3155ffGd (talk | contribs) (importing KB archive)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Knowledge Base


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