Hi all. I have a grid table, list, with an ID. If I click there on Detail, the detailform will open. Now I would like to do an event when I click on the detailicon. Is it possible to insert after click the ID In an other table with string like this: insert into t_tmp_id … where ID = my.selected.id.
the same event should be on the edit button. The Grid list is generated automaticly… thanks for help
hpthaeler wrote:
If I click there on Detail, the detailform will open.
You may use Page_Load server event of that page to execute the SQL. The id should be obtained from the query string.
What is the sql string to get the id form the actual record to insert it? Insert into t_tmp_id … ?
hpthaeler wrote:
If I click there on Detail, the detailform will open.
The selected ID should be passed to the detail table’s List page as URL parameter. You may just get it from by $_GET.
Or you may simply use Get() instead of $_GET. Please read about this global function from the generated phpfn.php file (assume v2020).