Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
prince.jace
Starting Member
1 Post |
 Posted - 2011-03-20 : 08:41:20
|
| .. Is this correct?..rs.Open "SELECT * FROM BorrowRecord WHERE Date >= ReturnDate", cn.. I aLways get a 3001 Run Time Error.... can someone pLease answer me..---Jace ObiasBSIT Student |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2011-03-20 : 15:13:21
|
| Are you able to run the select command from a SSMS window?If you are, check the properties of the ADO Recordset object. This might help: http://www.w3schools.com/ado/met_rs_open.asp |
 |
|
|
|
|
|
Comparison of Current Date to Dates in the DB