Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Handling Of Update Sql: Untouched Columns Are Updated As Well

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Handling Of Update Sql: Untouched Columns Are Updated As Well

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • June 7, 2007 at 2:29 pm #24213
      peterlaursen
      Participant

      I think every GRID based GUI does like this.  The only exception is TIMESTAMP fields defined as 'ON UPDATE CURRENT_TIMESTAMP' because the server should update those with now()!

      How should we check otherwise than comparing with data on the server?  That would demand the same or maybe more data to be transferred.

      You can work from the RESULT tab and not the DATA tab and only the displayed columns will be updated.

    • June 7, 2007 at 2:33 pm #24214
      ekod
      Member
      peterlaursen wrote on Jun 7 2007, 02:29 PM:
      I think every GRID based GUI does like this. The only exception is TIMESTAMP fields defined as 'ON UPDATE CURRENT_TIMESTAMP' because the server should update those with now()!

      How should we check otherwise than comparing with data on the server? That would demand the same or maybe more data to be transferred.

      You can work from the RESULT tab and not the DATA tab and only the displayed columns will be updated.

      Fast response 🙂

      Ok, agree about result tab, but since you dont check anyway with the server data when sending the update, you might check if a column has changed on the client side only, true?

      Plz correct me if i'm wrong..

    • June 7, 2007 at 3:50 pm #24215
      peterlaursen
      Participant

      yes .. it would be possible to set some kind of flag for every cell in the grid that tells if it had been touched or not!  But we do not do it and there are no such actual plans!

  • Author
    Posts
Viewing 2 reply threads
  • You must be logged in to reply to this topic.