By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,920 Members | 1,931 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,920 IT Pros & Developers. It's quick & easy.

Declare Cursor error while implementing SCROLL CURSOR

P: n/a
Hi,
I'm experiencing a problem while declaring scroll cursor. I'm
using Embeded SQL with C. my code is given below.

#ifdef SQLSRVR_RDBMS
EXEC SQL DECLARE CUR_DWNLD SCROLL CURSOR FOR SCURS;
EXEC SQL PREPARE SCURS FROM :S_QRY;
#endif
When i compile with nsqlprep, The error I'm getting is as below.
EXEC SQL DECLARE REGCDWNLD_CUR_CUST_DWNLD CURSOR SCROLL
SQLPREP: SQL Compile Error at line 709
OPEN REGCDWNLD_CUR_CUST_DWNLD
Error code: -19946

Cursor REGCDWNLD_CUR_CUST_DWNLD not declared
SQLPREP: SQL Compile Error at line 787
FETCH REGCDWNLD_CUR_CUST_DWNLD INTO : , : , :
, : , : ,
Error code: -19946

The code works without SCROLL option Is there any
problem with my declaration? If yes how can i correct this. I'm using
MSSQLSERVER 2000 and WINDOW 2000. Pre-compiler is NSQLPREP. Please
reply ASAP.

Dec 28 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a

"invy" <um*****@gmail.comschreef in bericht
news:11**********************@n51g2000cwc.googlegr oups.com...
Hi,
I'm experiencing a problem while declaring scroll cursor. I'm
using Embeded SQL with C. my code is given below.

#ifdef SQLSRVR_RDBMS
EXEC SQL DECLARE CUR_DWNLD SCROLL CURSOR FOR SCURS;
EXEC SQL PREPARE SCURS FROM :S_QRY;
#endif
When i compile with nsqlprep, The error I'm getting is as below.
EXEC SQL DECLARE REGCDWNLD_CUR_CUST_DWNLD CURSOR SCROLL
SQLPREP: SQL Compile Error at line 709
OPEN REGCDWNLD_CUR_CUST_DWNLD
Error code: -19946

Cursor REGCDWNLD_CUR_CUST_DWNLD not declared
SQLPREP: SQL Compile Error at line 787
FETCH REGCDWNLD_CUR_CUST_DWNLD INTO : , : , :
, : , : ,
Error code: -19946

The code works without SCROLL option Is there any
problem with my declaration? If yes how can i correct this. I'm using
MSSQLSERVER 2000 and WINDOW 2000. Pre-compiler is NSQLPREP. Please
reply ASAP.
Stop cross posting please. You're in the wrong group here.
Dec 28 '06 #2

P: n/a
invy wrote:
>
I'm experiencing a problem while declaring scroll cursor. I'm
using Embeded SQL with C. my code is given below.

#ifdef SQLSRVR_RDBMS
EXEC SQL DECLARE CUR_DWNLD SCROLL CURSOR FOR SCURS;
EXEC SQL PREPARE SCURS FROM :S_QRY;
#endif
Nothing to do with the standard C language. F'ups set.

--
Chuck F (cbfalconer at maineline dot net)
Available for consulting/temporary embedded and systems.
<http://cbfalconer.home.att.net>

Dec 28 '06 #3

P: n/a
Hi

Is #ifdef SQLSRVR_RDBMS defined correctly? Error 19946 says that the cursor
is not declared.

John
"invy" <um*****@gmail.comwrote in message
news:11**********************@n51g2000cwc.googlegr oups.com...
Hi,
I'm experiencing a problem while declaring scroll cursor. I'm
using Embeded SQL with C. my code is given below.

#ifdef SQLSRVR_RDBMS
EXEC SQL DECLARE CUR_DWNLD SCROLL CURSOR FOR SCURS;
EXEC SQL PREPARE SCURS FROM :S_QRY;
#endif
When i compile with nsqlprep, The error I'm getting is as below.
EXEC SQL DECLARE REGCDWNLD_CUR_CUST_DWNLD CURSOR SCROLL
SQLPREP: SQL Compile Error at line 709
OPEN REGCDWNLD_CUR_CUST_DWNLD
Error code: -19946

Cursor REGCDWNLD_CUR_CUST_DWNLD not declared
SQLPREP: SQL Compile Error at line 787
FETCH REGCDWNLD_CUR_CUST_DWNLD INTO : , : , :
, : , : ,
Error code: -19946

The code works without SCROLL option Is there any
problem with my declaration? If yes how can i correct this. I'm using
MSSQLSERVER 2000 and WINDOW 2000. Pre-compiler is NSQLPREP. Please
reply ASAP.

Dec 28 '06 #4

P: n/a
John Bell wrote:
>
Is #ifdef SQLSRVR_RDBMS defined correctly? Error 19946 says that
the cursor is not declared.
Please don't top-post. See the following links. And also please
do not post off-topic material to comp.lang.c. F'ups set.

--
Some informative links:
<http://www.geocities.com/nnqweb/>
<http://www.catb.org/~esr/faqs/smart-questions.html>
<http://www.caliburn.nl/topposting.html>
<http://www.netmeister.org/news/learn2quote.html>
<http://cfaj.freeshell.org/google/>
Dec 28 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.