|
-
January 7th, 2000, 02:49 PM
#1
Parameter in Querydef
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 .
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|