• Registered: 2014-09-04
  • Posts: 98

Topic: suggestion

when there is an error in the sql it shows you an example of the sql that caused the error - which you can click the notification an the do ctrl-c to copy - to get a copy of the sql query in question.

I would like the option to see the sql that runs when you setup a tablegrid, I'd like to be able to setup the tablegrid just like I want it, then copy that generated sql to a button and run it from there.

then I can use it with incremental searches, adjusted for filters and the table will stay looking exactly the same.

And maybe I can learn a bit more about sql queries from the generated examples.

  • Registered: 2014-02-14
  • Posts: 10,294

Re: suggestion

Thank you for the idea, I added this possibility in the beta version:
https://www.dropbox.com/s/ro1hs53q8rdv5 … a.zip?dl=0



Using script you can get SQL query which populate the TableGrid, example:

procedure Form1_Button1_OnClick (Sender: string; var Cancel: boolean);
begin
    ShowMessage(Form1.TableGrid.dbUpdate);
end;

Just press Ctrl+C to copy SQL query from message dialog.

Dmitry.