Set To Null

This topic is empty.

Viewing 6 reply threads

Author

Posts
- July 24, 2009 at 2:33 pm #11598
  
  tcrichard
  Member
  
  When manually setting fields to NULL, if you do more than one and hit refresh only the first one gets set to NULL.
  
  Looks like the update trigger isn't fired when using the right-mouse button to select the next field to NULL. Both fields change, but only the first is saved to the database.
- July 24, 2009 at 4:51 pm #29349
  
  peterlaursen
  Participant
  
  What we do is simple to paste the string “NULL” (without quotes) into the actual cell. When the row is saved what happens is described here:
  
  http://www.webyog.com/faq/content/8/99/en/…l-keywords.html
  
  (NULL does not get 'quoted' and it we be NULL and not 'NULL' as a string).
  
  What operations ypu perform in the GRID will have to be saved in either of the ways: 1) click save-icon 2) move grid-cursro to next row.
  
  Quote:
  
  ” to select the next field to NULL”
  
  .. I do not understand what “next field” is. Also I cannot know what UPDATE TRIGGER you are referring to. Do you have such defined ON the table?
- July 27, 2009 at 9:46 am #29350
  
  tcrichard
  Member
  
  peterlaursen wrote on Jul 24 2009, 05:51 PM:
  
  What we do is simple to paste the string “NULL” (without quotes) into the actual cell. When the row is saved what happens is described here:
  
  http://www.webyog.com/faq/content/8/99/en/…l-keywords.html
  
  (NULL does not get 'quoted' and it we be NULL and not 'NULL' as a string).
  
  What operations ypu perform in the GRID will have to be saved in either of the ways: 1) click save-icon 2) move grid-cursro to next row.
  
  .. I do not understand what “next field” is. Also I cannot know what UPDATE TRIGGER you are referring to. Do you have such defined ON the table?
  
  When I move to the next row by clicking the right mouse button, nothing is saved. I have to move to the next row (field) by using the left mouse button for it to save each time – adding a click, more annoying than anything else when there are a few to do.
- July 27, 2009 at 2:43 pm #29351
  
  peterlaursen
  Participant
  
  “I move to the next row by clicking the right mouse button, nothing is saved” ok .. that we will check in detail.
  
  But it works with arrow-down keyboard key too.
- July 27, 2009 at 2:52 pm #29352
  
  tcrichard
  Member
  
  peterlaursen wrote on Jul 27 2009, 03:43 PM:
  
  “I move to the next row by clicking the right mouse button, nothing is saved” ok .. that we will check in detail.
  
  But it works with arrow-down keyboard key too.
  
  Thanks. Apologies for not being clear earlier.
- July 28, 2009 at 5:09 am #29353
  
  navyashree.r
  Member
  
  Issue added in our tracker and will be available in next 8.13 RC release,
  
  http://code.google.com/p/sqlyog/issues/detail?id=1129
  
  Regards,
  
  Navya
- July 30, 2009 at 2:31 pm #29354
  
  Khushboo
  Member
  
  Hi,
  
  This issue is fixed and available in SQLyog 8.13 RC, publicly available!
  
  Please refer to:
  
  http://www.webyog.com/blog/2009/07/30/sqly…-been-released/
  
  Please let us know the status.
  
  Thank you.
  
  Regards,
  
  Khushboo
Author

Posts