Hello All

I am using VB 6.0 Enterprise Edition SP5 with a SQL 7.0 SP3 Database

I have the following Stored Procedure in SQL

CREATE PROCEDURE [dbo].[Check_Item]
	@RecordID varchar(15),
	@Item varchar(10),
	@Return bit OUTPUT
AS
	IF @Item = (SELECT [Item] 
                    FROM [dbo].[ItemTable] 
                    WHERE [RecordID] = @RecordID)

		SET @Return = 1
	Else
		SET @Return = 0

I then imported this Stored Procedure into my DataEnvironment.

The Parameters Tab lists four parameters
RETURN_TYPE (as Long)
RecordID (with Input and correct data type)
Item (with input asnd correct datatype)
Return (with input/output and correct datatype)

the Call Syntax shows
{? = CALL Check_Item ('?', '?', ?)}

HERE IS THE QUESTION <---------------

How do I call this from a cmdButton?
Why does it ask for the output as an input?
etc...

Any help would be greatly appreciated Thank you!