VB & Database, AddNew and "Edit" with ADO

AddNew and "Edit" with ADO

Author	Message
Troope #1 / 5	AddNew and "Edit" with ADO I have a drop down list binded to a field in a recordset. When i add a new record (AddNew), everything goes well. But when i want to "edit" a record (you don't need edit with ADO) the fields binded to a drop down list just won't change. All the other regular text box do the job correctly. What the hell is wrong!? Thanks! -- www.illusion.qc.ca
Sun, 09 Dec 2001 03:00:00 GMT

Troope #2 / 5	AddNew and "Edit" with ADO I was wondering, would i need to refresh the recordset cache? Maybe that would help... Quote: > I have a drop down list binded to a field in a recordset. When i add a new > record (AddNew), everything goes well. But when i want to "edit" a record > (you don't need edit with ADO) the fields binded to a drop down list just > won't change. All the other regular text box do the job correctly. What the > hell is wrong!? Thanks! > -- > www.illusion.qc.ca
Sun, 09 Dec 2001 03:00:00 GMT

Mark Wirema #3 / 5	AddNew and "Edit" with ADO Trooper, Your changes are actually happening, however, you cannot see them because you need to set the bookmark to the changed record. For example: adodc1.recordset.bookmark = adodc1.recordset.bookmark This should follow your update event. I hope this helps. Mark Quote: >I was wondering, would i need to refresh the recordset cache? Maybe that >would help... >> I have a drop down list binded to a field in a recordset. When i add a new >> record (AddNew), everything goes well. But when i want to "edit" a record >> (you don't need edit with ADO) the fields binded to a drop down list just >> won't change. All the other regular text box do the job correctly. What >the >> hell is wrong!? Thanks! >> -- >> www.illusion.qc.ca
Thu, 20 Dec 2001 03:00:00 GMT

Bill Hone #4 / 5	AddNew and "Edit" with ADO I've had this as well. .update doesn't seem to work reliably with combos & a whole host of other controls. .editmode doesn't report reliably either. .Move 0 seems to do the trick, but you have to put your error trapping in the willchange/ changed events instead. I don't think ADODC is finished properly .... Bill Quote: >>I was wondering, would i need to refresh the recordset cache? Maybe that >>would help... >>> I have a drop down list binded to a field in a recordset. When i add a >new >>> record (AddNew), everything goes well. But when i want to "edit" a record >>> (you don't need edit with ADO) the fields binded to a drop down list just >>> won't change. All the other regular text box do the job correctly. What >>the >>> hell is wrong!? Thanks! >>> -- >>> www.illusion.qc.ca
Tue, 08 Jan 2002 03:00:00 GMT

Cecil Le #5 / 5	AddNew and "Edit" with ADO Your record set is probably using client cursor. You need to use server-side cursor to get immediate update (but it's slow). Quote: > I've had this as well. > .update doesn't seem to work reliably with combos & a whole host of > other controls. > .editmode doesn't report reliably either. > .Move 0 seems to do the trick, but you have to put your error trapping > in the willchange/ changed events instead. > I don't think ADODC is finished properly .... > Bill > >>I was wondering, would i need to refresh the recordset cache? Maybe that > >>would help... > >>> I have a drop down list binded to a field in a recordset. When i add a > >new > >>> record (AddNew), everything goes well. But when i want to "edit" a record > >>> (you don't need edit with ADO) the fields binded to a drop down list just > >>> won't change. All the other regular text box do the job correctly. What > >>the > >>> hell is wrong!? Thanks! > >>> -- > >>> www.illusion.qc.ca
Tue, 08 Jan 2002 03:00:00 GMT

Page 1 of 1

[ 5 post ]