The problem with error -904 when a select statement returns an 
empty result set can be reproduced in VB using ADODB/ODBC;
Perl using DBD::ODBC; and C/C++ using ODBC.

You get error -904 if you repeatedly (number of repeats
required depends on available data space in your DB):
* create a statement handle
* execute a SQL statement that returns no data
* close the cursor (directly or indirectly)
* destroy the statement handle

N.B. You must repeatedly create and destroy the statement
handle. I have not been able to reproduce the error
when reusing the statement handle.

Do you need more info or test programs/scripts?

# schoen


_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to