Different behaviour of a SP called from SQL Query and from MS Access

[Mircea PREDUT]

Hi,
Please help me to elucidate a mistery !

I have a little SP in a database:

CREATE PROCEDURE XXXTest AS

DECLARE @a varchar(50)

SELECT @a = NULL

IF @a NOT IN ('x', 'y&#39
BEGIN
RAISERROR ('Error',16,1)
RETURN 0
END
RETURN 1

If I execute it from SQL Server, it returns 0. (after the error, of course).
If I execute it from MS ACCess through a Pass Through Query, it returns 0.
On the same server !!!
How could it to make me that ? I have been thought the SP is executed entirely on the server !!!

Thanks in advance clearing me the mind.
Mircea.

Subject:
From:
Date: Different behaviour of a SP called from SQL Query and from MS Access
Mircea PREDUT (office@unicapital.eunet.ro)
2/2/99 1:26:52 AM

Hi,
Please help me to elucidate a mistery !

I have a little SP in a database SQL Server 6.5 / Service Pack 4:

CREATE PROCEDURE XXXTest AS

DECLARE @a varchar(50)

SELECT @a = NULL

IF @a NOT IN ('x', 'y&#39
BEGIN
RAISERROR ('Error',16,1)
RETURN 0
END
RETURN 1

If I execute it from SQL Server, it returns 0. (after the error, of course).
If I execute it from MS ACCess through a Pass Through Query, it returns 0.
On the same server !!!
How could it to make me that ? I have been thought the SP is executed entirely on the server !!!

Thanks in advance clearing me the mind.
Mircea.

[alan]

On 2/2/99 1:35:28 AM, wrote:
> Subject:
From:
Date: Different behaviour of a SP called from SQL Query
> and from MS Access
Mircea PREDUT (office@unicapital.eunet.ro)
2/2/99
> 1:26:52 AM

Hi,
Please help me to elucidate a mistery !

I have a
> little SP in a database SQL Server 6.5 / Service Pack 4:

CREATE
> PROCEDURE XXXTest AS

DECLARE @a varchar(50)

SELECT @a = NULL

IF @a
> NOT IN ('x', 'y&#39
BEGIN
RAISERROR
> ('Error',16,1)
RETURN 0
END
RETURN 1

If I execute it from SQL
> Server, it returns 0. (after the error, of course).
If I execute it from
> MS ACCess through a Pass Through Query, it returns 0.
On the same server
> !!!
How could it to make me that ? I have been thought the SP is executed
> entirely on the server !!!

Thanks in advance clearing me the
> mind.
Mircea.


Stored procedures will return a value to the caller