Inserting/Updating data using query results

This topic is empty.

Viewing 7 reply threads

Author

Posts
- September 12, 2003 at 7:15 pm #8165
  
  SSS
  Member
  
  I have been using SQLyog for a while now and I think it's great that you can use the F8 command to edit a complex-join resultset!
  
  One question: Can you also INSERT new data from the F8 command? It would be great to be able to add new records and have SQLyog handle the mult-table inserts. I noticed the “empty” record at the end of the resultset, but I was afraid to experiment on a production db. (I'd like to try it myself, but haven't had time to set up a non-production db for experimenting.)
  
  By the way, EXCELLENT PRODUCT. I hope you continue your exceptional programming and make future versions even more robust!
  
  Thanks!
  
  [Edited for spelling]
- September 13, 2003 at 3:54 am #14900
  
  Ritesh
  Member
  
  Quote:
  
  Can you also INSERT new data from the F8 command? It would be great to be able to add new records and have SQLyog handle the mult-table inserts.
  
  Yes.
- October 8, 2003 at 7:48 am #14901
  
  tep
  Member
  
  Well, I have some problems with using F8.
  
  Sometimes i have to disconnect and connect to be able to edit the result – it is behaving very oddly.
  
  Is there any particular way how to use F8? OS: WinXP
  
  Thanks.
- October 8, 2003 at 8:08 am #14902
  
  Shadow
  Member
  
  Do you get any error message?
- October 8, 2003 at 8:41 am #14903
  
  tep
  Member
  
  No. The table is just gray and i can't edit. When i use the same SELECT after dis/connecting it usually works then.
- October 8, 2003 at 9:37 am #14904
  
  Shadow
  Member
  
  In such cases SQLyog explains why an update cannot be done. Just click on the “Reasons…” button.
- October 8, 2003 at 10:59 am #14905
  
  Shadow
  Member
  
  Hmmm… If I execute a select for update on a statement which resultset cannot be edited, then pressing the “Refresh” button causes the “Reasons…” button to disappear. Is this behaviour by design or just a little bug?
- October 8, 2003 at 11:03 am #14906
  
  Shadow
  Member
  
  There is definitely a bug because the “Reasons…” button just SEEMS to have disappeared, if I click the area where it should be displayed, then the button suddently appears!
Author

Posts