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!

Register Log in
  • Congratulations Mike Lewis 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

Sware

Programmer
Apr 19, 2005
124
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?
 
Sort by date Sort by votes
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.)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sal21
  • Locked
  • Question
Duplicate yes
Replies
5
Views
159
strongm
strongm
2009luca
  • Locked
  • Question
GET splitted value from node and sub node in treeview
Replies
1
Views
188
Andrzejek
Andrzejek
2009luca
  • Locked
  • Question
SET FOCUS on treeview node
Replies
6
Views
270
strongm
strongm
sal21
  • Locked
  • Question
No idea to export the msflexgrid in tabular output the complete calendar 1
Replies
6
Views
144
strongm
strongm
2009luca
  • Locked
  • Question
SET focus on node treeview 2
Replies
1
Views
289
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top