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

Inserting/Updating data using query results

forums › forums › SQLyog › Using SQLyog › Inserting/Updating data using query results

  • This topic is empty.
Viewing 6 reply threads
  • Author
    Posts
    • 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
Viewing 6 reply threads
  • You must be logged in to reply to this topic.