When I create a packout line of type "SQL Statement" I can use an SQL UPDATE command to change my data. My axample is this:
This code does not only inactivate the DocTypes in the active client but in all clients. A WHERE clause could help but at the time when I create the 2pack file I can not know which Client ID the user has when he uses PackIn.
One solution could be to automatically add an appropriate WHERE clause. I think this is nit easy to implement for all possible SQL texts. My idea is to allow context variables like this:
IMHO sounds like a good improvement
This patch works for me. I tested it with the given SQL command. Please review.
hi , for me, your suggest at forum is a solution, not only work-around.
but i already done a patch for it, so just attach here.
if you think chr(64) is ok, please help me close this ticket.
Thanks , I would like a solution like you proposed (escape) but in a more general approach - I think we have found similar issues in past with other functionalities - so implementing some ability to "escape" pounds on Env.parse could be good.
But that sounds like another ticket for improvement.
I'll close this one as per your advice.