When data are edited in masks as well as when you create and modify tables, your application will work together with the connected database. with the help of the SQL trace you can check and log the database transactions executed in the program flow.
After starting the SQL trace via the toolbar button, you first select in a transaction flag list the transactions or SQL statements which are to be logged.
If you confirm the transaction flag list, DataView will start the SQL trace. In the server directory <tmp>
and SQL log file will be created and maintained. Simultaneously the log list will open which displays the transactions or SQL statements. At first will be empty. After you executed database relevant functions in your application, you can update this list at any time using Refresh. It will then display all transactions or SQL statements that were executed after starting the trace. In order to finish SQL trace, simply close the log list.