Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Connection String: Deleted=Yes/No

Status
Not open for further replies.

Sware

Programmer
Apr 19, 2005
124
0
0
US
Can someone please tell me if I'm correct or incorrect with repect to Deleted=Yes/No in a Connection String:

Deleted=Yes: Deleted records are ignored. Same effect as command SET DELETED ON

Deleted=No: Can access all records. Same effect as command SET DELETED OFF

Plus, a question: what's the effect on rs.RecordCount?
 
I've done what I should have done before posting - testing!
The testing shows that the explanations in my origianl post are correct, and also that the Deleted= setting DOES affect RecordCount. (By the way, before anyone wonders, I am using a client-side cursor on the recordset.)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top