Results 1 to 4 of 4

Thread: [RESOLVED] Option in ADODC or DataGrid components to update existing row?

Threaded View

  1. #1

    Thread Starter
    Addicted Member kutlesh's Avatar
    Join Date
    Jun 2018
    Location
    Skopje, Macedonia
    Posts
    211

    Resolved [RESOLVED] Option in ADODC or DataGrid components to update existing row?

    I am using ADODC component with select query to feed the DataGrid component with data.

    Everything works fine except, the thing I don't know how to update existing row instead of adding new one.
    There are two columns in the datagrid which serve as keys. When i add another row with the same combination of those two key columns, the datagrid saves another row in the table.
    Yes, the table should be set to have two keys, but its not, and i don't want to set keys, because its a legacy application and I might break other parts of it.

    Is there some option to tell either ADODC or DataGrid component to update existing row with that same combination of keys instead of adding a new row?

    Or I should add keys to my table, and explore where the application will break next?
    Last edited by kutlesh; Dec 5th, 2019 at 04:27 AM.

Tags for this Thread

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