January 7th, 2000, 01:49 PM
How to use this Parameter in Querydef.Please help me witth an example
I did like this
Dim db as database
dim rs as recordset
dim qdef as querydef
set db = opendatabase()
set qdef= db.Createquerydef()
qdef.name = "temp"
qdef.sql = "select * from emp where empno = ?"
qdef.parameter("empno") = inputbox("enter empno")
set rs = qdef.openrecordset(dbopendynaset)
......
I am getting an error at place qdef.parameter("empno") = inputbox("enter empno")
I just want to know how to use the parameter property of qdef .
I did like this
Dim db as database
dim rs as recordset
dim qdef as querydef
set db = opendatabase()
set qdef= db.Createquerydef()
qdef.name = "temp"
qdef.sql = "select * from emp where empno = ?"
qdef.parameter("empno") = inputbox("enter empno")
set rs = qdef.openrecordset(dbopendynaset)
......
I am getting an error at place qdef.parameter("empno") = inputbox("enter empno")
I just want to know how to use the parameter property of qdef .