Results 1 to 2 of 2

Thread: Updating Changes in a DataGrid back to the DB

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Oct 1999


    I have a DataEnvironment control that creates a DBGrid 6.0 control. The Control is based on an SQL statment that grabs data from a local Access 2000 database.

    I've set the Command Object's LockType = adLockOptimistic so that it will support updates to the database. Now, whenever a user retypes in a field, I get the following error - "Error Occurred while trying to update the column value". I have added NO updating code and really don't know what event to add it to if I had any. How can I write a value back to the database after a field looses focus after being changed?


  2. #2
    Hyperactive Member
    Join Date
    Jun 1999
    Calgary Alberta


    Doesn't DBrid have a sub called LeaveCell? I'd put it there. I don't use data bound controls, or at least I don't bind them. I find it much easier to write the database accesses in code then allowing the controls to do it. It takes more code and sometimes may run slower, but I feel like I have better control and the only database activity is what I make. As far as I remember, after binding a control to a database, changing values in that control updates the database automatically. I'm not sure how to stop it from doing this while still binding it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width