• From: Gotham City
  • Registered: 2017-12-31
  • Posts: 406

Topic: data to grid

hello DriveSoft..
how to show data in grid using SQLEcecute command
in Script on button click

  • Registered: 2014-06-25
  • Posts: 865

Re: data to grid

http://myvisualdatabase.com/help_en/com … n_sql.html

  • From: Gotham City
  • Registered: 2017-12-31
  • Posts: 406

Re: data to grid

thanks.  but i asked that how can we use this type of queries in pascal script and show data in grid.

  • Registered: 2014-06-25
  • Posts: 865

Re: data to grid

http://myvisualdatabase.com/help_en/scr … egrid.html deploy SqlValue

SQLExecute('SELECT data FROM table WHERE what_you_are_looking_for='your filter')

  • Registered: 2015-11-13
  • Posts: 652

Re: data to grid

blackpearl8534.
Here is another way:

procedure Form1_Button1_OnClick (Sender: string; var Cancel: boolean);
begin
    Form1.Tablegrid1.dbSQL:='SELECT id, lastname, firstname FROM employees'; 
    Form1.Tablegrid1.dbGeneralTable := 'employees'; 
    Form1.Tablegrid1.dbListFieldsNames :='delete_col,Last Name,First Name'; 
    Form1.Tablegrid1.dbSQLExecute;
end;
  • From: Gotham City
  • Registered: 2017-12-31
  • Posts: 406

Re: data to grid

if we use multiple tables for query then how to write this script

  • Registered: 2015-11-13
  • Posts: 652

Re: data to grid

You simply write the appropriate SQL in the SELECT statement. You can place left joins and where clauses, etc in the SELECT statement as needed for additional tables.