Hello, I'm having a little trouble getting the VB ADODC (ADO data control) to work consistently with MySQL through the MyODBC driver. I'm using VB 6; I have a form with many text boxes drawing from an ADODC (via their DataField/DataSource properties). I also have a second ADODC (linked to the same recordset) and a DataList control listing keys to drive the display of particular rec's in the form textboxes (to be really lazy, and just to see how much I could get away with, I used the ADODC1.Recordset.Filter property to change the data displayed in the textboxes). First blow and everything worked - the bound textboxes update the underlying data - but after a few test runs, and repeated updates, things began to unravel a bit: the updates are no longer 'automatic'. In fact, no update occurs at all. When I change data in a text box and then click a different item in the list (an action that formerly caused the edited record to be updated and the new rec to display in the textboxes) I get the error: 'Operation was cancelled.' This just started t happen, I didn't change any properties of any controls. So maybe something, due to the sloppy way I was doing things, just manifested itself? Subsequent to this change in behavior, I tried playing with various properties of the ADODC Mode property and others. No avail. Any ideas? Ultimately, I wouldn't mind doing all the updating 'manually' via code and SQL statements; but I'd still like the text box values to link to the data control (just to ignore updates) without a hack. Can I specify read-only with the ADO data control/MyODBC connection? Thanks for any insight... Scott Scott Pease | WATERBORNE ENVIRONMENTAL, INC. Staff Geologist | http://www.waterborne-env.com | voice (703) 777-0005 | fax (703) 777-0767 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
