Update only certain fields

Thread is closed for posting
2 posts, 0 answers
  1. Charlie
    Charlie avatar
    6 posts
    Member since:
    Aug 2010

    Posted 08 Oct 2010 Link to this post

    This may be a simple question but  -

    Is it possible to update only a couple data field when working with a mapped OEM objects - which is mapped to the whole table ?

    For example:  table Customer
    generated ORM object will include all fields .. i..e   25.

    Well I only want to update 2 fields - or fields that have been changed  - ( the generated store procedure is requiring all fields) - is this possible via the ORM object?  Configuration setting?


  2. Jan Blessenohl
    Jan Blessenohl avatar
    707 posts

    Posted 11 Oct 2010 Link to this post

    Hello Charlie,
    If you have to use stored procedures for update operations OpenAccess can only update all fields. It is far too complicated to provide stored procedures for all combinations of changed fields. If you can avoid using stored procedures our generated SQL will only update the changed values.

    Jan Blessenohl
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
Back to Top