Hi Mark, SQL Studio is connected by an ODBC Driver. The SQL commands OPEN and FETCH doesn't belong to the ODBC SQL Syntax and will never run. But SQL Studio displays a result window and displays the result of your SELECT command.
Regards Burkhard Burkhard Diesing [EMAIL PROTECTED] SAP DB, SAP Labs Berlin http://www.sapdb.org/ -----Original Message----- From: Mark Bruk [mailto:[EMAIL PROTECTED]] Sent: Mittwoch, 17. Oktober 2001 17:08 To: sapdb Subject: Re: OPEN CURSOR and FETCH errors in SQL Studio Elke, All are the same error messages. OPEN temp_products [SAP AG][SQLOD32 DLL][SAP DB]Syntax error or access violation;-3008 INVALID KEYWORD OR MISSING DELIMITER. OPEN CURSOR temp_products [SAP AG][SQLOD32 DLL][SAP DB]Syntax error or access violation;-3008 INVALID KEYWORD OR MISSING DELIMITER. OPEN temp_products CURSOR [SAP AG][SQLOD32 DLL][SAP DB]Syntax error or access violation;-3008 INVALID KEYWORD OR MISSING DELIMITER. FETCH temp_products INTO products_id, products_name [SAP AG][SQLOD32 DLL][SAP DB]Syntax error or access violation;-3008 INVALID KEYWORD OR MISSING DELIMITER. FETCH temp_products INTO @products_id, @products_name [SAP AG][SQLOD32 DLL][SAP DB]Syntax error or access violation;-3008 INVALID KEYWORD OR MISSING DELIMITER. FETCH FIRST temp_products [SAP AG][SQLOD32 DLL][SAP DB]Syntax error or access violation;-3008 INVALID KEYWORD OR MISSING DELIMITER. FETCH FIRST temp_products INTO products_id, products_name SAP AG][SQLOD32 DLL][SAP DB]Syntax error or access violation;-3008 INVALID KEYWORD OR MISSING DELIMITER. FETCH FIRST temp_products INTO @products_id, @products_name SAP AG][SQLOD32 DLL][SAP DB]Syntax error or access violation;-3008 INVALID KEYWORD OR MISSING DELIMITER. ----- Original Message ----- From: "Zabach, Elke" <[EMAIL PROTECTED]> To: "'Mark Bruk'" <[EMAIL PROTECTED]> Sent: Wednesday, October 17, 2001 1:36 PM Subject: RE: OPEN CURSOR and FETCH errors in SQL Studio > Hi, > > in this case it would be nice to know WHICH error (errornumber/errortext) > was given. Otherwise it is hard to guess what the problem may be. > Please send the extended info to the list again. > > Elke > SAP Labs Berlin > > -----Original Message----- > From: Mark Bruk [mailto:[EMAIL PROTECTED]] > Sent: Mittwoch, 17. Oktober 2001 01:41 > To: sapdb > Subject: OPEN CURSOR and FETCH errors in SQL Studio > > > I am using SQL Studio and can not execute a FETCH ... > > DECLARE temp_products CURSOR FOR SELECT * FROM products FOR REUSE > // no error > > OPEN temp_products > // ERROR > OPEN CURSOR temp_products > // ERROR > OPEN temp_products CURSOR > // ERROR > > FETCH temp_products INTO products_id, products_name > // ERROR > FETCH temp_products INTO @products_id, @products_name > // ERROR > FETCH FIRST temp_products > // ERROR > FETCH FIRST temp_products INTO products_id, products_name > // ERROR > FETCH FIRST temp_products INTO @products_id, @products_name > // ERROR > > CLOSE temp_products > // No error >
