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 Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Saving disconnected recordset
Yes! That's it! Must've been the static and adLockBatchOptimistic. balves had it rite. Now I'm back in love with the new ado. Thanks folks!- drbyte
- Post #7
- Forum: Visual Basic (Classic)
-
Saving disconnected recordset
That is also what I thought. But I've tried many syntax combinations for the recordset cursortype, cursorlocation locktype update type (including those you mentioned), modifying rs.fields("field") vs bound textbox etc, but to no avail. Maybe in the next ADO version...- drbyte
- Post #5
- Forum: Visual Basic (Classic)
-
Saving disconnected recordset
Ok, thanks. That's unfortunate. Can't leave it open due to WAN limitations and the users tendacy to keep the program open all day, and tooo many fields to track for changes (sounds like an ordeal). Guess I'll try to save off the employee # when they hit the edit button to unlock the textboxes...- drbyte
- Post #3
- Forum: Visual Basic (Classic)
-
Saving disconnected recordset
Using vb6, ado2.5 & sqlserver 7.0, I get the recordset(rst) with adUseClient, trying various combinations of keyset/dynaset/static/unspecified and various locks, populate form textboxes with fields then set the rst.activeconnection = nothing and the textboxes datasource=rst and datafield =...- drbyte
- Thread
- Replies: 6
- Forum: Visual Basic (Classic)
