I am triggering this query from a button in a ListView.
My query is:
EXEC DeleteFileGlobal @file_id = {{qryFilesFiltered.data[i].file_id}}, @table={{location.value}}
Which runs correctly.
My Confirmation message is:
#### Are you sure you want to delete {{qryFilesFiltered.data[i].name}}
But i
is always 0 here so it asks if I want to delete the wrong file.
I guess my workaround would be to fire a JS query that triggers the delete query with additonalScope.