×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Sorry about that, the routine to get more results is called
JDBC_getMoreResults() (not JDBC_moreResults). This is just a mistake in
the comments.
Having said that... it's not clear to me why you're asking about this.
You've already determined that there aren't any more results... that's
what it means if JDBC_ExecCall returns '0' -- there aren't any result
sets to retrieve. You would only call JDBC_getMoreResults() for a
stored procedure that returns two or more result sets... the
JDBC_execCall() would tell you about the first one, and
JDBC_getMoreResults() would tell you if there are more (and move the
read cursor to the next one).
If you look at the code for your procedure, it does not appear to return
any result set when there's an error. The result set comes from the
select statement at the bottom -- and if it returns 1 or 2, it never
reaches that select statement. So, there is no result set to retrieve.
If you're looking to get the number 1 or 2, that's not a result set.
Try calling JDBC_getUpdateCount().
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
