>
> How can i use this return value in my VBA code ? Maybe i should ask this
> question in an other Newsgroup. Please
> let me know in which one
>

In my VBA Code i wrote:

<fniedermeyer@aareon.com> wrote:

>Hello Newsgroup !
>
>My Tools are:
>Windows 2000, VBA(Access 2000) and MS SQL Server 7.0
>
>I wrote in an *.adp project (Access 2000) a Stored Procedure "xyz"
>with parameters a,b
>
>In my VBA Code i wrote:
>
>Dim par As New ADODB.Parameter
>
>Cmd.CommandType = adCmdStoredProc
>Cmd.CommandText = "[prcSucheUNRWIAEStichtag]"
>
>Set par = Cmd.CreateParameter("@a", adInteger)
>Cmd.Parameters.Append par
>
>Set par = Cmd.CreateParameter("@b", adVarChar, adParamInput, 5)
>Cmd.Parameters.Append par
>
>.......
>Cmd.Parameters(0) = a
> Cmd.Parameters(1) = b
>
> Set rsTemp = Cmd.Execute
>
>Now my Problem is the following:
>
>there is an error in the stored procedure and i want to use something like
>this:
>
>if @idontknow = '000000000'
>
>Begin
> return(1) -- Something <>0
>end
>
>How can i use this return value in my VBA code ? Maybe i should ask this
>question in an other Newsgroup. Please
>let me know in which one
>
>Greetings
>Frank
>