I doubt AIE is a good product to do this.
Why not use SQL directly?
Company environment issue, firewall only opened ARS special port but not database port. Therefore I wanna to truncate the Form data by ARS connection. However in AIE, I tried ARS connection cannot use SQL directly.
You can use ArDriver command prompt tool.
There is one API you can use to run SQL.
The command is "sql"
Is it a one time job you are looking for? If yes in that case you can run an escalation as well to delete the records in the table/form.
Thanks for your idea. Is ArDriver command fired in server side? My production environment cannot direct access server to execute the command. Only can access ARS by specific port 7000.
Thanks for your idea. I am currently using the similar way to delete table/form data in ARS by "Button" with Active-Link (Direct SQL) . However, it must be separate with AIE operation.
Yes, it will fire in server side.
It's like ARS sending a SQL to the DB.