2
Contributors
1
Reply
2
Views
8 Years
Discussion Span
Last Post by AndreRet
0

I have posted to the previous unmoved post -

Your problem lies in your string syntax -

str = "select * from emp where Filename= &key "

Try -

str = "select * from emp where Filename=" & "'" & key & "'", conn, AdOpenStatic, AdLockOptimistic

This should return the values you are looking for.

Edited by AndreRet: n/a

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.