hi friends,
pl. help finding solution for this.
stored procedure in sql server.
create procedure sp_employee @ename nvarchar(10)
as select * from employee where ename like @ename + '%'
cmd1_click()
set rs=new adodb.recordset
strsql = strsql = "exec sp_employee'" & txtename.Text & "'"
rs.open strsql,cn,adopenstatic
set datagrid.datasource = rs
end sub
when i pressing/clicking cmd1, i am getting error like run time error 7004 and The rowset is not bookmarkable.
what is the reason/problem. please mail me solution as early as possible.
_______________
if i am trying in different way of writing & i am getting results.
i.e., without passing any IN parameter to procedure.
simple select statement.
store procedure like this
create procedure sp_emp as select * from employee
cmd_click()
set rs=new recordset()
strsql="exec sp_emp"
rs.open strsql,cn,adopenstatic
set datagrid.datasource=rs
end sub.
here i am not getting any error what is the different between 2 prog.
Thanks in advance.
bye.
