Question:
How can I tell whether a query’s DELETE command was successfully sent to the database?
Solution:
To do so, you can use the return of query’s EXECUTE command to know whether it was successfully executed or not.
Script being executed in the Click event of a buton on screen showing the query’s Execute retrieval:
aux1 = Screen.Item(“Query1”).Execute()
MsgBox aux1
If the query was successfully execute, the retrieval is TRUE; otherwise, it is FALSE. That is how you can tell the command was retrieved. In case something happens in the database this information will not be returned to E3; however, it will appear in E3’s log.