VB & Database, Update method not working

Update method not working

Author	Message
Al Gardine #1 / 6	Update method not working Hi. I am using VB6's Data Environment tool to create my recordsets. I use datacombo boxes to bind to the data. All works well when viewing and navigating the data. However, the update method will not work. The concept is this. The user will be "working" a project using this app. He may or may not change various fields. If he does change fields, I want him to be able to "save" the changes since he may choose to quit the app at any time. I created a command button with the code: deProjectManagement.rsActiveProjects.Update This will not update the recordset. My workaround is this: deProjecttManagement.rsActiveProjects.Move 1 deProjecttManagement.rsActiveProjects.Move -1 This works. Why will the update method not work? As additional information, I used the de{filter} to determine that the datachanged property is not set to TRUE when the combo box is changed, but the databindings.item(0).datachanged property is TRUE. And deProjecttManagement.rsActiveProjects.editmode is 0. Any help you can provide would be much appreciated. Al
Tue, 25 Oct 2005 05:10:19 GMT

Dave War #2 / 6	Update method not working Check the locktype property of the opened recordset and make sure it is adLockOptimistic and not adLockBatchOptimistic. Dave Quote: > Hi. I am using VB6's Data Environment tool to create my recordsets. I use > datacombo boxes to bind to the data. All works well when viewing and > navigating the data. However, the update method will not work. The concept > is this. The user will be "working" a project using this app. He may or > may not change various fields. If he does change fields, I want him to be > able to "save" the changes since he may choose to quit the app at any time. > I created a command button with the code: > deProjectManagement.rsActiveProjects.Update > This will not update the recordset. My workaround is this: > deProjecttManagement.rsActiveProjects.Move 1 > deProjecttManagement.rsActiveProjects.Move -1 > This works. Why will the update method not work? As additional > information, I used the de{filter} to determine that the datachanged property > is not set to TRUE when the combo box is changed, but the > databindings.item(0).datachanged property is TRUE. And > deProjecttManagement.rsActiveProjects.editmode is 0. Any help you can > provide would be much appreciated. > Al
Tue, 25 Oct 2005 17:08:31 GMT

Al Gardine #3 / 6	Update method not working Dave, Thanks for the response. Cursor type is dynamic, lock type is optimistic (not batch), and cursor location is server-side. Al Quote: > Check the locktype property of the opened recordset and make sure it is > adLockOptimistic and not adLockBatchOptimistic. > Dave > > Hi. I am using VB6's Data Environment tool to create my recordsets. I use > > datacombo boxes to bind to the data. All works well when viewing and > > navigating the data. However, the update method will not work. The concept > > is this. The user will be "working" a project using this app. He may or > > may not change various fields. If he does change fields, I want him to be > > able to "save" the changes since he may choose to quit the app at any time. > > I created a command button with the code: > > deProjectManagement.rsActiveProjects.Update > > This will not update the recordset. My workaround is this: > > deProjecttManagement.rsActiveProjects.Move 1 > > deProjecttManagement.rsActiveProjects.Move -1 > > This works. Why will the update method not work? As additional > > information, I used the de{filter} to determine that the datachanged property > > is not set to TRUE when the combo box is changed, but the > > databindings.item(0).datachanged property is TRUE. And > > deProjecttManagement.rsActiveProjects.editmode is 0. Any help you can > > provide would be much appreciated. > > Al
Tue, 25 Oct 2005 20:59:24 GMT

J.D. #4 / 6	Update method not working You want client side cursors don't you? So that client can modify data and update it back on the server? Quote: > Dave, > Thanks for the response. Cursor type is dynamic, lock type is optimistic > (not batch), and cursor location is server-side. > Al > > Check the locktype property of the opened recordset and make sure it is > > adLockOptimistic and not adLockBatchOptimistic. > > Dave > > > Hi. I am using VB6's Data Environment tool to create my recordsets. I > use > > > datacombo boxes to bind to the data. All works well when viewing and > > > navigating the data. However, the update method will not work. The > concept > > > is this. The user will be "working" a project using this app. He may > or > > > may not change various fields. If he does change fields, I want him to > be > > > able to "save" the changes since he may choose to quit the app at any > time. > > > I created a command button with the code: > > > deProjectManagement.rsActiveProjects.Update > > > This will not update the recordset. My workaround is this: > > > deProjecttManagement.rsActiveProjects.Move 1 > > > deProjecttManagement.rsActiveProjects.Move -1 > > > This works. Why will the update method not work? As additional > > > information, I used the de{filter} to determine that the datachanged > property > > > is not set to TRUE when the combo box is changed, but the > > > databindings.item(0).datachanged property is TRUE. And > > > deProjecttManagement.rsActiveProjects.editmode is 0. Any help you can > > > provide would be much appreciated. > > > Al
Wed, 26 Oct 2005 15:19:54 GMT

Vlad Vissoultche #5 / 6	Update method not working first, a question are you 100% positive that you tested this with a CommandButton with CausesValidation property set to tTrue? (not toolbar, not menu item Click event, etc.) anyway, try to call ValidateControls method on your form ([Me.]ValidateControls where [...] means optional syntax) HTH, </wqw> Quote: > Hi. I am using VB6's Data Environment tool to create my recordsets. I use > datacombo boxes to bind to the data. All works well when viewing and > navigating the data. However, the update method will not work. The concept > is this. The user will be "working" a project using this app. He may or > may not change various fields. If he does change fields, I want him to be > able to "save" the changes since he may choose to quit the app at any time. > I created a command button with the code: > deProjectManagement.rsActiveProjects.Update > This will not update the recordset. My workaround is this: > deProjecttManagement.rsActiveProjects.Move 1 > deProjecttManagement.rsActiveProjects.Move -1 > This works. Why will the update method not work? As additional > information, I used the de{filter} to determine that the datachanged property > is not set to TRUE when the combo box is changed, but the > databindings.item(0).datachanged property is TRUE. And > deProjecttManagement.rsActiveProjects.editmode is 0. Any help you can > provide would be much appreciated. > Al
Thu, 27 Oct 2005 22:32:08 GMT

Al Gardine #6 / 6	Update method not working Sorry for the slow response. I just got a chance to get back to this. I changed to client-side cursor and update seems to be working. However, I can't get the data to "validate". For example, if I put a bad date value in the text box ("15/17/03"), the update method does not error out (nor will the recordset update). If I change records, it then errors out. The causesvalidation property is set to true on the text box, and I execute the validatecontrols method on the form, but there is no indication programmatically that the entry is bad. The only indication I get is when I try to go to a different record. Any ideas? Thanks, Al Quote: > You want client side cursors don't you? So that client can modify data and > update it back on the server? > > Dave, > > Thanks for the response. Cursor type is dynamic, lock type is optimistic > > (not batch), and cursor location is server-side. > > Al > > > Check the locktype property of the opened recordset and make sure it is > > > adLockOptimistic and not adLockBatchOptimistic. > > > Dave > > > > Hi. I am using VB6's Data Environment tool to create my recordsets. I > > use > > > > datacombo boxes to bind to the data. All works well when viewing and > > > > navigating the data. However, the update method will not work. The > > concept > > > > is this. The user will be "working" a project using this app. He may > > or > > > > may not change various fields. If he does change fields, I want him > to > > be > > > > able to "save" the changes since he may choose to quit the app at any > > time. > > > > I created a command button with the code: > > > > deProjectManagement.rsActiveProjects.Update > > > > This will not update the recordset. My workaround is this: > > > > deProjecttManagement.rsActiveProjects.Move 1 > > > > deProjecttManagement.rsActiveProjects.Move -1 > > > > This works. Why will the update method not work? As additional > > > > information, I used the de{filter} to determine that the datachanged > > property > > > > is not set to TRUE when the combo box is changed, but the > > > > databindings.item(0).datachanged property is TRUE. And > > > > deProjecttManagement.rsActiveProjects.editmode is 0. Any help you can > > > > provide would be much appreciated. > > > > Al
Sun, 06 Nov 2005 23:59:42 GMT

Page 1 of 1

[ 6 post ]