stored procedur

[shravyas]

i wrote this stored procedur in sql server 2000, and i used this procedure vb6. i got error .
error is:Run_time error '-247217904)80040e10)':
procedure 'spInsert_CSQRelation ' expect parameter
'@wid',which was not supplied.

CREATE procedure spInsert_CSQRelation
@wid integer,
@phno integer ,
@whname varchar(200)
as
declare @idAffected int
begin
insert into warehouse

(wid,phno,whname)
values

(@wid,@phno,@whname)

Set NoCount On
Select @idAffected As 'idAffected'

return
end
exec spInsert_CSQRelation @wid,@phno,@whname
GO

[DrBunchman]

It may be that you are calling the stored procedure with a null value - try putting a watch on all your parameter variables in debug or adding a message box right before you call the procedure which will show you their values.

If this doesn't help then please print the code which calls the stored procedure.

Dr B

[ck9663]

i wrote this stored procedur in sql server 2000, and i used this procedure vb6. i got error .
error is:Run_time error '-247217904)80040e10)':
procedure 'spInsert_CSQRelation ' expect parameter
'@wid',which was not supplied.

CREATE procedure spInsert_CSQRelation
@wid integer,
@phno integer ,
@whname varchar(200)
as
declare @idAffected int
begin
insert into warehouse

(wid,phno,whname)
values

(@wid,@phno,@whname)

Set NoCount On
Select @idAffected As 'idAffected'

return
end
exec spInsert_CSQRelation @wid,@phno,@whname
GO

if your procedure call is included in your create stored proc,and your @wid is a variable outside your stored proc, what is it's value? how did you call it in vb?

-- ck