Ok, so waiting for the possibility to auto execute a custom sql query in grid for a future release, how should I write this in my project?
procedure Form1_onShow (Sender: string; Action: string); //display form containing
this is the query which works great with a button:
SELECT *
FROM
(
SELECT 'Nb Ready' as "Status", COUNT(id) AS Count FROM computers where id_status="3"
UNION ALL
SELECT 'Nb Defect' as "Status", COUNT(id) AS Count FROM computers where id_status="2"
UNION ALL
SELECT 'Nb To be Restaged' as "Status", COUNT(id) AS Count FROM computers where id_status="4"
) temp
The funny thing is that the grid refreshes automatically when I change the status of a record, would it be possible to initiate this refresh when loading the form and hide the button?