hi friends this is Ram
I m making a Project On VB6.0
On Worker Details for a company
I want to create automatic worker Id Generate
what i do,
I create a stored procedure for this problem
but there are a errer when i exec my stored procedure
my table and Proce are give following
\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ \\\\\\\
create table worker
(
wid char(5),
wfname varchar(15),
wlname varchar(15),
wdobirth varchar(10),
wgender char(8)
)
select * from worker
insert into worker values('W00','Ram','Yadav','23/03/1987','M')
create procedure prcWorker
@incre int output
as
declare @wid char(5)
select @wid = max(wid) from worker
select @incre = convert(int,substring(@wid,2,4)) + 1 return
ERROR://Procedure or Function 'prcWorker' expects parameter '@incre', which was not supplied.//
Please Help Me Immediate ,Please
and Please give me solution on My e-mail id raj_sargum@rediff.com
which one i m using always.
Please Help me ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Regard's Ram Yadav (India)