× 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.





I am using SK's JDBCR4 service program to retrieve date from a MS SQL
Server.

Below is a stored procedure that validity checks the passed parameters and
returns if either the details do not exist or the requester is not
authorised.

If the tests are passed the procedure returns the data set correctly.

Only when the procedure determines there is a problem and returns using the
"return 1" I do not receive any result set.

I am using isResultSet = JDBC_execCall( prepStmt );

This returns a 0 (isResultSet = 0)

The documentation in the JDBCR4 has the following;

*+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
* JDBC_ExecCall(): Execute SQL statement that calls a stored
* procedure
*
* call = (input) callable statement to execute
*
* Returns *ON if first result is a ResultSet
* or *OFF if first result is an update count
*
* Use JDBC_moreResults(), JDBC_getUpdateCount() and
* JDBC_getResultSet() to get results of this function
*+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

The referenced procedure JDBC_moreResults() does not exist in the JDBCR4
version I have - and I am not sure if that is what I need to us or not.

I am hoping that someone has come across this situation and can advise a
way to receive the returned value ?

Here is a snipet of the stored procedure ...

<begin_snip>
USE [History]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[details]

@BookingID int,
@OperatorID int

AS
BEGIN

declare @BookingLookup int
declare @OperatorLookup int

set @BookingLookup = (select BookingID from History.
dbo.Booking where BookingID = @BookingID)

set @OperatorLookup = (select OperatorID from History
.dbo.Booking TB with (nolock)

if @BookingLookup is null
begin
print 'Booking does not exist'
return 1
end

else if @OperatorLookup <> @OperatorID

begin
print 'You are not authorised'
return 2
end

else

begin

select TB.BookingID as [Booking ID]
,
<end_snip>


Don Brown



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.