Delete secected rows

here's one.

it is a constant. stores value(in that case, an integer) such as integer, string, real, etc...
it is accessible all through out your script in any function or procedure.

i want storing such value in the constant so that later on, i can only set it in the top.

4 is the column index on the grid. so say for example you change the arrangement of the grid, like adding a column before the current index 4, all you have to do is change the constant value, then all is well.

check that i used the constant ID_IDX in different procedures

Form1_Button5_OnClick
Form1_TableGrid1_OnChange
Form1_Button4_OnClick
Form1_Button6_OnClick

I could just set it to its corresponding value(4) like for example

SQLExecute('DELETE FROM Names WHERE id='+Form1.TableGrid1.Cell[4,i].AsString);

and in the other procedure but, then, when you decided to re-arrange your grid (like adding a column), what will happen is you will have to look on all the procedure with that index 4 and a big chance(this happens a lot) to omit some value that needs updating and sometimes it'll not throw an error, but will give an unexpected or unnoticeable output and will eat your time to just looking for that code/s.

Check on the Settings of the TableGrid1, notice that I added Names.id right after Names.tsek  it is at 5th column (index:4)

Hi V_Pozidis, Hi Brian,
Some time ago I had a quite similar requirement (attached is a simplified version).
Users could 'mark' a record for deletion but only the supervisor could actually perform the deletion (individually or in bulk) which was done on a weekly basis once the list had been checked.
To mark a record for deletion,  just click on the appropriate cell in the tablegrid.
If you are logged on as a supervisor, the 'deletion' button is enabled otherwise the 'deletion' button is greyed out.
Valid user ids are admin (password admin) and xx (password xx).
Maybe this gives you some ideas?
Regards,
Derek.