Topic: show data on tablegrid

Hi friend,
           Would you like to guide in a problem?
Is there way to show data on tablegrid of a table using SQL? For example I have project with a form, form1 and a tablegrid1 and a table sales with three columns, date, items and value. How can I show data in table sales on tablegrid1 using SQL statement?

Thanks

Re: show data on tablegrid

See attached

Post's attachments

Attachment icon sales.zip 4.2 kb, 80 downloads since 2020-08-07 

@thezimguy

Re: show data on tablegrid

Hi thezimguy
Thank you to attached project but my mistake I want to ask about script. Is there any way to display data of a table on tablegrid using script.
Thank you

Re: show data on tablegrid

Form1.Tablegrid1.dbSQL := 'SELECT `date`,`items`,`value` FROM `sales`';
Form1.TableGrid1.dbSQLExecute;
brian

Re: show data on tablegrid

Thank you all to guide me.